Hi Fernando,

Can you explain why you cannot use dbfs and DBCs?

What I usually do is to create a project with a DBC contaning remote views and dbfs with meta data and INCLUDE that into the executable. So the end product is only the executable, you don't have to deliver DBCs and DBFS, but in fact you are using them since they are IN the executable.

I use remote views for data entry forms, and mainly SPT for queries and populating drow down combos. RVs have the advantage they can automatically change datetimes into date. With SPT you'll have to jump through some hoops to solve that problem. I use a connection string (SQLSTRINGCONNECT()) stored encrypted in a SQLconnect.TXT file in order to connect to the database. In VFP8 and later you can open a view with the connection handle retrieved from SQLSTRINGCONNECT().

HTH,

Walter,