>Hello all,
>
>Questions
>=========
>
>1. How can I connect and call SQL server store procedure from VFP ?
nConnHandle = SQLCONNECT('sqlremote')
=SQLEXEC(nConnHandle, 'use mysqlserverdb')
=SQLEXEC(nConnHandle, 'my_storedprocedure')
>2. I tried to insert records 1000000 in a #temp table in sql server and it was very slow (7 minutes). In VFP is 7 seconds !!. There is any way to make SQL server faster? (The server is 6 processors, 2GB ram, RAID5).
>
>3. I continued my tests with SQL statements and VFP is still faster. The problem is that SQL server does not have the concept of VFP cursor ?
>
>4. There is a document of explaining this behaviour (SQL Server / VFP) ?
How do you insert the data? What mechanism? SQL passthrough, RVs?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."