Database

C-P-User-3 wrote: I just want to set up a system that I can use to track a set of people So create a custom system - basically write your own simple database. You either used fixed record sizes or create an index to find records. Probably easiest if the index is in another file. If you go this route then make sure you use an API in your code that completely separates the rest of the code from the storage mechanism. That way you can replace it later on if you want.

For db designing check this site http://www.databaseanswers.org/data_models/[^] For calculations, it's based on logic. You could discuss with your lead & team. thatraja FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion HTML Marquee & its alternatives Nobody remains a virgin, Life screws everyone :sigh:

You got answer there[^]. FYI Potential enhancements to ASPState[^] Where Are ASPStateTempApplications and ASPStateTempSessions Tables?[^] thatraja FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion HTML Marquee & its alternatives Nobody remains a virgin, Life screws everyone :sigh:

Wrong forum. You could find many HTML/javascript calendars in web. Please use Google. thatraja FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion HTML Marquee & its alternatives Nobody remains a virgin, Life screws everyone :sigh:

Closer to what do you want. Justify text in SQL Reporting Services[^] Full justification in reporting services 2008 needed[^] thatraja FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion HTML Marquee & its alternatives Nobody remains a virgin, Life screws everyone :sigh:

Use the Suppress if duplicated[^] option thatraja FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion HTML Marquee & its alternatives Nobody remains a virgin, Life screws everyone :sigh:

Thank you. I found one 20 mb free on appharbor

http://go.microsoft.com/fwlink/?LinkId=87352[^] http://msdn.microsoft.com/en-us/library/vstudio/ms751502(v=vs.90).aspx[^] Useful links. Download the samples. Compile/Debug to formulate approach to development ...

Nebilo wrote: First I put (PayItem,Description and unit)on a single table, Why? Normalization consists of a set of rules that one can apply, one after the other. As is, the table is in 0NF. A "normalized" model is usually in BCNF (3NF+). That means that one verifies the rules for each level. If you follow the rules (!) we'd get exactly the same model. Nebilo wrote: what should i do now? Start at the wikipedia, and see how you can turn your pile of data into 1NF. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

:sigh: Alright lets try a little hand holding! Does you VB app extract data from sql server - yes Is there a connection to the database - yes Is the "other PC" on the same network as the server - you need to answer this question If the answer is yes then all you need to do is deploy your application to the "other PC" I STRONGLY suggest you do a LOT of reading on developing and deploying applications, your question indicates you have too little knowledge to complete this task. Never underestimate the power of human stupidity RAH

Your question isn't clear. If you want to store a single 'item' without respect to the type of the item and you need to have no limit on the size then you would use a single column which has a blob (binary not character data.) If you want to keep a hint as to what type of data is in that column then you could create another string\text column which stores the name of the type like 'url', 'txt', 'img', etc. muraliDarenKassi wrote: is it possible?if so,how? If the above is a correct re-statement of your question then the above is also the answer.

I tried this but didn't work too! SELECT cleaner_id, cleaner_name FROM cleaners WHERE cleaner_id NOT IN (SELECT cleaner_id FROM job_orders WHERE job_order_date = param_job_order_date AND start_time BETWEEN param_start_time AND param_end_time OR end_time BETWEEN param_start_time AND param_end_time) AND is_active = TRUE ORDER BY cleaner_name; Please help... Technology News @ www.JassimRahma.com

choose a reporting tool[^],learn how to connect to the database, learn how to develop reports in the chosen tool and build your reports. Deploy your reports in your chosen tool. .Net does not have a specific reporting tool. Never underestimate the power of human stupidity RAH

PrissySC wrote: Is there a better way (xml) that would prove to be better? Space is not an issue; however, length of time to display is, as always, a major factor. That of course depends on how the user is accessing it. PrissySC wrote: I would save as a file and link to the file, but I fear that in the manner suggested they will not map the network drive to a consistent letter at all workstations. Again this depends on how the users access it. PrissySC wrote: What have you done or would you do? Depends on the system but at least one file based solution is to provide an application\web server which can return a file URL and where the server permissions allow only for read only access into the file system. The database then returns something that can be massaged into a file url. There are other solutions and other factors such as how many files, what sort of access, how often does access occur, size of files, goals of project, etc.

Visual Representation of SQL Joins[^] :) Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Assuming you're not using SQL 2000 or earlier, you shouldn't be using the text data-type[^]: http://technet.microsoft.com/en-us/library/ms187993.aspx[^] ntext , text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Thanks a lot its now working I was using a backtick on rapping \r\n. The correct command is as follows. LOAD DATA LOCAL INFILE 'C:\\temp\\test.csv' INTO TABLE bd_george.test FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' (id,name); Regards George Tsiga STUDENT

Super Lloyd wrote: am about to create 18 brand new table ...I don't want to make thing more complicated Then I suggest you might want to take another look at the first part.

Have another upvote for the sqlfiddle link. Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln

Hi There, Thank you for the quick response, I changed the GenealogyId to = NULL. It still doesn't work, I have never heard of guid. How does it work and how is the code implemented? Can you explain? Look forward to hearing from you soon. Thanks