Re: ODBC Update
From: Juan Alonso (jacinc2_at_hotmail.com)
Date: 03/25/05
- Next message: Juan Alonso: "Re: SQLPASSTHROUGH UPDATE"
- Previous message: Juan Alonso: "Re: SQLPASSTHROUGH UPDATE"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Mar 2005 16:46:08 -0500
I can help you.
I had this same problem and at first it kinda boggled me but here goes for
you ...
The reason that the table is returning the same data is because you are
adding the VIEW/CURSOR you are creating to your database and not deleting it
when you go to requery with the same query you were using before hand.
If this is not the case then you need to post part of your code so we can
see cuz I do not know any other reason why it will return the same data and
not update it.
Unless you are missing one of two in your code.
1) =CURSORSETPROP("SendUpdates", .T.) if you are strictly using PassThrough
and creating a CURSOR.
2) DBSetProp("CUSTOMER","View","SendUpdates",.T.) if you are using partially
PassThrough with a VIEW.
These are the only two things I can currently think of .. considering your
description of the problem, unless its in your method of updating the data.
Good luck and I hope you kick in with this.
Have a nice day,
Johnny5
"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:OJFEvNtEFHA.548@TK2MSFTNGP14.phx.gbl...
> Hi Kam,
>
> When you change the table content are you moving the record pointer so
> that the field is actually updated?
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
>
>
> "Kam" <Kam@discussions.microsoft.com> wrote in message
> news:AD481FC5-AF51-4623-832B-F538ADDB3FBC@microsoft.com...
>>I created a DSN for the VFP free table.
>>
>> When I 1st queries the table, using SQL Pass thru it work correctly.
>> Then I use use under VFP environment and change the table content and
>> queries the tables use the SQL Pass Thru.
>>
>> The table information remain the same.
>>
>> I don;t know where is the problem.
>> But I think either the info in the free table is not updated or the
>> queries
>> still look at the old info in the buffer.
>>
>> Can anyone help?
>
>
- Next message: Juan Alonso: "Re: SQLPASSTHROUGH UPDATE"
- Previous message: Juan Alonso: "Re: SQLPASSTHROUGH UPDATE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
