ReaperUser101

Use a TADOQuery , or (if you have the component) TCDSADOQuery. Simply set the connection-string in the properties grid and [CODE] QueryName.SQL.Add (' SQL TO BE Executed '); QueryName.ExecSQL; [/CODE]

Hi everyone I'm trying to connect and display data in a TDBGrid (component) from an .mdf (made in sql) and connect it to a Delphi application. the .mdf is on the desktop and my databases name is Attach. If anyone has any clues or advice please let me know! Many …

Hi chathuD There is a way to create a SQL database in Visual studio. Through creating it that way your app is portable. I suggest you check that out. Sorry for this vague answer, but i will get back to you tomorrow with the full details on the how to! …

Hi people , I have an easy question(but lack the knowledge in Delphi), I have a piece of code that i want to run but don't want to type it over for every time it has to be run (not very good coding then). Is there a way i can …

Hi guys The just of what i whant to do is read lines of text from a file until it reaches a delimiter and then execute that text in a query and repeat the process till there is no more text. I am using Delphi 6(don't have a choice) and …

Hi everyone Im trying to take my SQl and "SCRIPT" it to a .sql file(accomplished) and add it to my Delphi(accomplished) and then [U]connect them[/U] and show the data in a TDBGrid but seem to be battling. The .sql file adds and creates the Database in delphi but I don't …

A simple way would be to read each line as strings and then use simple string manipulation like the following: [CODE] var before, after : string; begin // Try to replace all occurrences of a or A to THE before := 'This is a way to live A big life'; …