Hi group,
I am in  serious problem regarding the VFP8 and share ConnectionHandle in
remote views.
But nobody is there to help me.

I am using an ODBC connection to MySQL.  I want to know the number of
affected rows after executing an UPDATE statement.
I am trying:
<snip>

I need the following line corrected to put a numeric value(mdiscount*100)
into a character field called "amount". Currently, it's just putting the the
value of mdiscount*100 rounded the the nearest % and showing no decimals.
The value of mdiscount is .602 so the replace is putting ...

i need a syntactically correct version of this statement
for foxpro:
update k:\dhs\prof_enc\dia_prof.dbf
set text1a = substr(text1a, 1,21) + medical +

today while our app was running something one of the main datafiles (.dbf).
after scrambling around a bit trying to figure what the heck happened i
finally decided i would have to punt.
when i went to copy a slightly out-of-date backup onto the system i noticed

I'm trying to issue the following query in VB. NET through ADO using
the FoxPro OLE DB driver.
SELECT DISTINCT TTOD(date) From Orders ORDER BY date Desc
This query works fine when I run it from the FoxPro command window.

The _tally var isn't giving the recordset count when a requery is done
against a remote view to a SQL Server table.  Is this a known confirmed bug,
and is there a workaround?
- Bryan

any idea to use the upsizing method for transfer existing
dbf to MySQL table ?
Thanks

I have a master database containng the fields
z5,profession,type & have 3 other databases containing the
data I want to select
Field names, type,length are the same