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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL UPDATE currency field problem
I try to update a currency field in my ms acess db from a program in VB6 (sp5). Herefor I execute a SQL string-command over the active connection. The variable total is also declared a currency type variable. The error message tells me that there is an error in the command and that it is about...- JakeNL
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
Date Insert results in erroneous date
I Have a huge problem trying to insert a date in a date/time field of a jet db. Firstly I create a SQL string to perform the operation and later on I execute this SQL string on the connection. Afterwards some very weird data can be found in the real field if I look in it with the Visual data...- JakeNL
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
