VB & Database, [ODBC Visual FoxPro Driver]Invalid argument value

[ODBC Visual FoxPro Driver]Invalid argument value

Author	Message
Dan Dougla #1 / 8	[ODBC Visual FoxPro Driver]Invalid argument value Err.Number=-2147467259 Err.Source=Microsoft OLE DB Provider for ODBC Drivers Err.Description=[Microsoft][ODBC Visual FoxPro Driver]Invalid argument value I am getting this error when I a SELECT the records I want from the database and I go to the first and only record and change its values in the recordset rs(0)= whatever rs(1) = whatever and so on. The error occurs when I am calling rs.update. I am using the exact same code to fill in a new record entry (not editing a current record by calling rs.addnew instead of rs.movefirst and it works fine and updates fine. I am opening the database the way i normally do and the way it normally works. It seems Ive been at this error for a long time and just cant figure it out. Oh and by the way I get an Operation is not allowed in this context error if I try to close the recordset instead of updating it (when a record is being edited) Crazy ehh? I am using VB5/AD02.1
Mon, 10 Mar 2003 03:00:00 GMT

Julian Milan #2 / 8	[ODBC Visual FoxPro Driver]Invalid argument value Could be that you are using the wrong TYPE of recordset? Try SnapShot type. -- Julian Milano Quote: > Err.Number=-2147467259 > Err.Source=Microsoft OLE DB Provider for ODBC Drivers > Err.Description=[Microsoft][ODBC Visual FoxPro Driver]Invalid argument value > I am getting this error when I a SELECT the records I want from the database > and I go to the first and only record > and change its values in the recordset > rs(0)= whatever > rs(1) = whatever > and so on. > The error occurs when I am calling rs.update. > I am using the exact same code to fill in a new record entry (not editing a > current record by calling rs.addnew instead of rs.movefirst and it works > fine and updates fine. > I am opening the database the way i normally do and the way it normally > works. It seems Ive been at this error for a long time and just cant figure > it out. > Oh and by the way I get an Operation is not allowed in this context error if > I try to close the recordset instead of updating it (when a record is being > edited) > Crazy ehh? > I am using VB5/AD02.1
Tue, 11 Mar 2003 09:08:31 GMT

jacques thero #3 / 8	[ODBC Visual FoxPro Driver]Invalid argument value Are you using server side or client side cursors? I believe the driver only supports client side...
Tue, 11 Mar 2003 03:00:00 GMT

Dan Dougla #4 / 8	[ODBC Visual FoxPro Driver]Invalid argument value I dont believe ADO supports Sanpshot or maybe they define it as something else, but a Snapshot in DAO just gives the user whats in the recordset but does not allow updates. Thanks though. Quote: > Could be that you are using the wrong TYPE of recordset? Try SnapShot type. > -- > Julian Milano > > Err.Number=-2147467259 > > Err.Source=Microsoft OLE DB Provider for ODBC Drivers > > Err.Description=[Microsoft][ODBC Visual FoxPro Driver]Invalid argument > value > > I am getting this error when I a SELECT the records I want from the > database > > and I go to the first and only record > > and change its values in the recordset > > rs(0)= whatever > > rs(1) = whatever > > and so on. > > The error occurs when I am calling rs.update. > > I am using the exact same code to fill in a new record entry (not editing > a > > current record by calling rs.addnew instead of rs.movefirst and it works > > fine and updates fine. > > I am opening the database the way i normally do and the way it normally > > works. It seems Ive been at this error for a long time and just cant > figure > > it out. > > Oh and by the way I get an Operation is not allowed in this context error > if > > I try to close the recordset instead of updating it (when a record is > being > > edited) > > Crazy ehh? > > I am using VB5/AD02.1
Tue, 11 Mar 2003 03:00:00 GMT

Dan Dougla #5 / 8	[ODBC Visual FoxPro Driver]Invalid argument value Its all client side. Quote: > Are you using server side or client side cursors? > I believe the driver only supports client side...
Tue, 11 Mar 2003 03:00:00 GMT

Dan Dougla #6 / 8	[ODBC Visual FoxPro Driver]Invalid argument value I found the culprit, there was nothing wrong with my coding at all it was the table structure, even though I dont know why.. I had been using a memo field, but when I was updating or adding to the taable i didnt add anything to this field i just left it blank, but it was allowed to accept null values.. This worked fine when adding a record but when modifying a record and keeping the memo field blank it gave me that stupid error. If anyone can explain why this happened because it makes absolutly no sense at all. I just changed memo to charachter 254 and it works fine. Quote: > I dont believe ADO supports Sanpshot or maybe they define it as something > else, but a Snapshot in DAO just gives the user whats in the recordset but > does not allow updates. > Thanks though. > > Could be that you are using the wrong TYPE of recordset? Try SnapShot > type. > > -- > > Julian Milano > > > Err.Number=-2147467259 > > > Err.Source=Microsoft OLE DB Provider for ODBC Drivers > > > Err.Description=[Microsoft][ODBC Visual FoxPro Driver]Invalid argument > > value > > > I am getting this error when I a SELECT the records I want from the > > database > > > and I go to the first and only record > > > and change its values in the recordset > > > rs(0)= whatever > > > rs(1) = whatever > > > and so on. > > > The error occurs when I am calling rs.update. > > > I am using the exact same code to fill in a new record entry (not > editing > > a > > > current record by calling rs.addnew instead of rs.movefirst and it works > > > fine and updates fine. > > > I am opening the database the way i normally do and the way it normally > > > works. It seems Ive been at this error for a long time and just cant > > figure > > > it out. > > > Oh and by the way I get an Operation is not allowed in this context > error > > if > > > I try to close the recordset instead of updating it (when a record is > > being > > > edited) > > > Crazy ehh? > > > I am using VB5/AD02.1
Tue, 11 Mar 2003 03:00:00 GMT

stewartmc.. #7 / 8	[ODBC Visual FoxPro Driver]Invalid argument value I know there is some quirk in Access which you have to access the memo field last or it flags up some stupid error message... You could try this... Stewart. In article Quote: > I found the culprit, there was nothing wrong with my coding at all it was Quote: > the table structure, even though I dont know why.. > I had been using a memo field, but when I was updating or adding to the Quote: > taable i didnt add anything to this field i just left it blank, but it was Quote: > allowed to accept null values.. This worked fine when adding a record but Quote: > when modifying a record and keeping the memo field blank it gave me that Quote: > stupid error. > If anyone can explain why this happened because it makes absolutly no sense Quote: > at all. > I just changed memo to charachter 254 and it works fine. in message > > I dont believe ADO supports Sanpshot or maybe they define it as something Quote: > > else, but a Snapshot in DAO just gives the user whats in the recordset but Quote: > > does not allow updates. > > Thanks though. > > > Could be that you are using the wrong TYPE of recordset? Try SnapShot Quote: > > type. > > > -- > > > Julian Milano > > > > Err.Number=-2147467259 > > > > Err.Source=Microsoft OLE DB Provider for ODBC Drivers > > > > Err.Description=[Microsoft][ODBC Visual FoxPro Driver]Invalid argument Quote: > > > value > > > > I am getting this error when I a SELECT the records I want from the Quote: > > > database > > > > and I go to the first and only record > > > > and change its values in the recordset > > > > rs(0)= whatever > > > > rs(1) = whatever > > > > and so on. > > > > The error occurs when I am calling rs.update. > > > > I am using the exact same code to fill in a new record entry (not Quote: > > editing > > > a > > > > current record by calling rs.addnew instead of rs.movefirst and it Quote: > works > > > > fine and updates fine. > > > > I am opening the database the way i normally do and the way it Quote: > normally > > > > works. It seems Ive been at this error for a long time and just cant Quote: > > > figure > > > > it out. > > > > Oh and by the way I get an Operation is not allowed in this context Quote: > > error > > > if > > > > I try to close the recordset instead of updating it (when a record is Quote: > > > being > > > > edited) > > > > Crazy ehh? > > > > I am using VB5/AD02.1 Sent via Deja.com http://www.deja.com/ Before you buy.
Fri, 28 Mar 2003 03:00:00 GMT

Dan Dougla #8 / 8	[ODBC Visual FoxPro Driver]Invalid argument value I just got rid of it all together. 254 chars is suffient, although representing a path it could be longer but it probably wont be since it will be a mapped path Quote: > I know there is some quirk in Access which you > have to access the memo field last or it flags up > some stupid error message... You could try > this... > Stewart. > In article > > I found the culprit, there was nothing wrong > with my coding at all it was > > the table structure, even though I dont know > why.. > > I had been using a memo field, but when I was > updating or adding to the > > taable i didnt add anything to this field i > just left it blank, but it was > > allowed to accept null values.. This worked > fine when adding a record but > > when modifying a record and keeping the memo > field blank it gave me that > > stupid error. > > If anyone can explain why this happened because > it makes absolutly no sense > > at all. > > I just changed memo to charachter 254 and it > works fine. > in message > > > I dont believe ADO supports Sanpshot or maybe > they define it as something > > > else, but a Snapshot in DAO just gives the > user whats in the recordset but > > > does not allow updates. > > > Thanks though. > > > > Could be that you are using the wrong TYPE > of recordset? Try SnapShot > > > type. > > > > -- > > > > Julian Milano > > > > > Err.Number=-2147467259 > > > > > Err.Source=Microsoft OLE DB Provider for > ODBC Drivers > > > > > Err.Description=[Microsoft][ODBC Visual > FoxPro Driver]Invalid argument > > > > value > > > > > I am getting this error when I a SELECT > the records I want from the > > > > database > > > > > and I go to the first and only record > > > > > and change its values in the recordset > > > > > rs(0)= whatever > > > > > rs(1) = whatever > > > > > and so on. > > > > > The error occurs when I am calling > rs.update. > > > > > I am using the exact same code to fill in > a new record entry (not > > > editing > > > > a > > > > > current record by calling rs.addnew > instead of rs.movefirst and it > > works > > > > > fine and updates fine. > > > > > I am opening the database the way i > normally do and the way it > > normally > > > > > works. It seems Ive been at this error > for a long time and just cant > > > > figure > > > > > it out. > > > > > Oh and by the way I get an Operation is > not allowed in this context > > > error > > > > if > > > > > I try to close the recordset instead of > updating it (when a record is > > > > being > > > > > edited) > > > > > Crazy ehh? > > > > > I am using VB5/AD02.1 > Sent via Deja.com http://www.deja.com/ > Before you buy.
Fri, 04 Apr 2003 03:00:00 GMT

Page 1 of 1

[ 8 post ]