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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by G4U
-
Access97 - Update Memo Field
How can I view the text in a Memo field using an Acess database. This line doesn't work: Memo.Lines.Text:=Table2.FieldByName('Notes').AsString; But it worked fine on a Paradox table! I'M using an ADOTable in Delphi 6.- G4U
- Post #9
- Forum: Microsoft: Access Other topics
-
Access97 - Update Memo Field
I can I view the text in a Memo field using an Acess database. This line doesn't work: Memo.Lines.Text:=Table2.FieldByName('Notes').AsString; But it worked fine on a Paradox table! I'M using an ADOTable in Delphi 6.- G4U
- Post #8
- Forum: Microsoft: Access Other topics
-
Syntax error in query?
Ok I figured out the main problem. This (") and that ([]). I must give credit to:hilfy on the Access date format using the(#)sign in a Date field. Upon doing some reading, I totally forgot about the square brackets required in Access on field-names which contain special characters i.e A_OT...- G4U
- Post #5
- Forum: Embarcadero: Delphi
-
Syntax error in query?
I've tried the code posted, however I still get a "Syntax Error" from the Access database. So let me explain some details: SIXTOUR and OVERTIME: are both Floating point values. DATE_IS is of ftDate. The rest of the fields are simple strings e.g., (ftString)...These datatypes are the same in both...- G4U
- Post #4
- Forum: Embarcadero: Delphi
-
Syntax error in query?
This code works great in Paradox using the BDE, but returns an Error using quering an Access database: for i:= 0 to ListView1.Items.Count-1 do With ListView1 do begin Query1.SQL.Clear; Query1.SQL.Add('UPDATE "'+Table2.TableName+ '" SET OVERTIME...- G4U
- Thread
- Replies: 6
- Forum: Embarcadero: Delphi
