Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ADOQuery returns a negative value
Sorry, solved the problem - I was using ADOQuery.RecNo to tell me the Record Count, and hence it was telling me the location of the pointer in the returned data set - not the number of records returned.- ozzydaws
- Post #2
- Forum: Embarcadero: Delphi
-
ADOQuery returns a negative value
Hi Everyone, In one of my units I have an ADOQuery component, which I initialize like so: with ADOQuery1 do begin Close; ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+frm_Technician.databaselocation+'btbse_ScienceBookings.mdb;Persist Security Info=False'...- ozzydaws
- Thread
- Replies: 2
- Forum: Embarcadero: Delphi
-
TADOCommand and TADOQuery do not accept INSERT statement as valid
Brilliant, thank you for your replies. As always, hours of agonising was solved with a few characters. The working code is below: ADOCommand1.CommandText := 'INSERT INTO [tbl_Bookings] ([User], [Period]) VALUES (15, ''p1'')'; ADOCommand1.CommandType := cmdText; ADOCommand1.Execute...- ozzydaws
- Post #4
- Forum: Embarcadero: Delphi
-
TADOCommand and TADOQuery do not accept INSERT statement as valid
Hi everyone, when I try and run this code, Delphi tells me I the INSERT statement has a syntax error when, as far as I can see, it doesn't. ADOCommand1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+frm_LogIn.SpreadSheetLocation+'btbse_ScienceBookings.mdb;Persist...- ozzydaws
- Thread
- Replies: 10
- Forum: Embarcadero: Delphi
