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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ado - updating vfp database
again... I've tried .. cmd.CommandText = "UPDATE session SET " _ & "session.cl_date = CTOD('" & Date & "') " _ & "WHERE session.user = ?" this also works thanks beebaw- nbob
- Post #6
- Forum: Visual Basic (Classic)
-
ado - updating vfp database
thanks for the help... I've just tried this Dim MyDate As String MyDate = "01/01/2000" cmd.CommandText = "UPDATE session SET " _ & "session.cl_date = {" & MyDate & "}, " _ & "session.cl_time = ? " _...- nbob
- Post #5
- Forum: Visual Basic (Classic)
-
ado - updating vfp database
hmmm I'm trying to update the field with todays date but ado seems to pass NULL not the correct date. If I set the field to allow NULL I don't get the error but I don't get the date either. Is it somthing to do with the format of the date? thanks- nbob
- Post #3
- Forum: Visual Basic (Classic)
-
ado - updating vfp database
I'm trying to update a fvp dbc from vb 6.0 using ado 2.6. code like... ConnectionString = "Provider=vfpoledb.1;Data " _ & "Source=..\star.dbc" Set objConnection = New adodb.Connection objConnection.Open (ConnectionString) cmd.ActiveConnection =...- nbob
- Thread
- Replies: 5
- Forum: Visual Basic (Classic)
-
ado vfp database
I'm trying to update a fvp dbc from vb 6.0 using ado 2.6. code like... ConnectionString = "Provider=vfpoledb.1;Data " _ & "Source=..\star.dbc" Set objConnection = New adodb.Connection objConnection.Open (ConnectionString) cmd.ActiveConnection =...- nbob
- Thread
- Replies: 1
- Forum: Microsoft: FoxPro
