Search found 56 matches

by jpmoschi
Tue Jun 30, 2020 12:55 pm
Forum: Welcome
Topic: VFP TEST. Sqlexec big querys
Replies: 3
Views: 3502

VFP TEST. Sqlexec big querys

<t>Hi Robert, a vfp cursor can be in memory or on disk depending on size. It is not decided by the programmer.<br/>
After executing that query you can see the file in a configurable location.<br/>
? sqlexec (1, "select ...", "SQLBIGRESULT")<br/>
? dbf ()<br/>
This returns C: USERS JUANPC APPDATA ...
by jpmoschi
Mon Jun 29, 2020 4:23 pm
Forum: Welcome
Topic: VFP TEST. Sqlexec big querys
Replies: 3
Views: 3502

VFP TEST. Sqlexec big querys

<t>Good morning Forum , <br/>
I continue evaluating xsharp to migrate from visual foxpro. <br/>
Detect problems by running huge queries like<br/>
"select top 1000000 from dbo.bigtable"<br/>
It does not produce errors but it never ends eithe<br/>
<br/>
I guess it is not a timeout problem xq the query ...
by jpmoschi
Fri Jun 19, 2020 6:36 pm
Forum: Visual FoxPro
Topic: I need to understand the name resolution in XSharp.
Replies: 1
Views: 2624

I need to understand the name resolution in XSharp.

<r>I need to understand the name resolution in XSharp. <br/>
My background is VFP where "names" are resolved in order of loading into memory.<br/>
For example:<br/>
do <B><s>[b]</s>ProcOrFunc<e>[/b]</e></B> with par1, par2, ...<br/>
First of all, the name ProcOrFunc is searched in memory It may ...
by jpmoschi
Wed Jun 17, 2020 4:46 pm
Forum: Visual FoxPro
Topic: sqlexec
Replies: 3
Views: 3147

sqlexec

<t>my problem is: the CLR does'nt find the DLLs. In Console application i puted the dll in the folder bindebug and it functioned ok.<br/>
But in the template project Windows Form VFP the same solution do not correct the problem. <br/>
I not prefer to use GAC never. How could i resolve all dll ...
by jpmoschi
Tue Jun 16, 2020 10:25 pm
Forum: Visual FoxPro
Topic: sqlexec
Replies: 3
Views: 3147

sqlexec

<r>hi Forum<br/>
I have a problen with sqlexec function <br/>
<B><s>[b]</s> LRESULT = SqlExec(_HANDLE, "Select getdate() dummy ","dummyselect",miarray )<e>[/b]</e></B><br/>
Lresult is -1 but i am shure, some sql command are correctly executed because I checked it in my MS SQL Profiler.but<br/>
In ...
by jpmoschi
Thu Jun 11, 2020 5:04 pm
Forum: Product
Topic: index
Replies: 10
Views: 3376

index

<r>good morning forum:<br/>
I am new here, I am getting to xsharp from foxpro and I try to know the degree of completion of the product:<br/>
<br/>
My question is this:<br/>
<COLOR color="blue"><s>[color=blue]</s><B><s>[b]</s>sqlexec ("select * from customers", "mysqlresult")<br/>
<B><s>[b]</s ...