How i may asign image from ms sql to object image in vfp9.
In vfp9 in object image is properties PictureVal.
From ms sql I get type gen and vfp9 must have blob or memo.
I must first save record to dbf file after i must change type field to memo

I have just started using views with a MYSQL back end database. What method
can I use to lock a record on the remote database?
Obviously when I use a view the table is downloaded to my PC as a kind of
offline dataset so I assume using RLOCK is not going to have any effect.

Friends,
Can I create an ODBC (user DSN and system DNS)  from within my VFP8
application? I dont have VFP database or tables used in my application. I am
using Firebird, SQL Server and Access databases

A vfp9 database accessing SQL via ODBC with sharable remote view 'A'
will share
the connection (IE have the same connection handle) only when view 'A'
is

a lot is been written already about this subject, but most of the
problems mentioned were caused by concatenations. I use a very simple
view. I use a filter on this view so i just see the records which
hasn't been processed yet, Retouren.verwerkt = ( 'N' ).

I'm a novice VFP 8 programmer and want to access a Postgresql database via a
DSN. Here's my code:
poConnection = CREATEOBJECT("adodb.connection")
WITH poConnection

I have a big problem with cross-table:
GCDIR='C:\' && there is C_SI table
SELECT c_si.shopcode,c_si.viz,c_si.war FROM (GCDIR)+'c_si';
GROUP BY c_si.typ,c_si.shopcode,c_si.viz;

I know that UNION joins the outputs of 2 or more SELECT SQLs leaving out the
common records.
What i want is the common records only. i.e. the opposite of UNION.
how do i achieve that. I tried using NOT UNION to negate the results. but it

i'm a bit confused by SQL pass through. When i execute a select command into
a cursor and i refresh my forms recordsource property, i can use the fetched
data in my form. As far as i know, the data has been fetched from the server
into the cursor and now there is no link between the ...

How is it possible to select all the records from a parameterised view
without having to supply default values?
For example I have a view that selects orders between two given dates which
I user a filter of Between ?dStart AND ?dEnd.