Hi,
I'm very new in SQL and VBA, so maybe it's very simple, but I'm not being able to use one or more Recordsets in a SQL SELECT sentence.
Having 2 recordsets (I've them still opened) what I need is to relate them in a sql populating a new recordset....
...
rsOne
rsTwo
ssql="SELECT...
Hello,
Foxpro 2.5a has sql sentences (but I can't find info).
Is it possible to stablish a connection to a SQL server database from Foxpro 2.5a?
If possible, what would be the code for it?
I need to run a stored procedure which is in a SQL database..
Thanks,
rvctips
Hi Dovydas,
I'm running large files under Xp, from Foxpro 2.5a, with no problem.
I've experienced some speed troubles whith antivirus. If this is your case, just try to stop antivirus and check it again.
Later you will need to set up your antivirus.
HTH,
rvctips
Hello Cholewinsky,
Thanks for your clarification.
Hi Stesvet,
As told before I don't have corrupted database, it's just it says "NOT A DATABASE FILE". Then you press Enter an go on...
I used to have the trouble you say, but thas was with the Foxbase (not Foxpro..). With the change, all was...
It's really hard !!
Right now I do have a FOXUSER for each user and the awesome is when I did the change it seemed to me it worked fine .... but one hour later it's again with the same message "NOT A DATABASE FILE"... !!
When I was trying the changes I run the app in the Win98SE server, I...
Of course I've already set up the cell with the DATA-VALIDATION, but I want to have the user's control and so avoid writting in wrong cells.
So, my question is, under VBA is possible to use the VALIDATION's performances?
TIA
Hi,
I'm writting some code where with a CommandButton I'd like to input a value in a cell, but it must match a VALIDATION list.
I know I can write a loop and check if the input is ok (if the value is in the VALIDATION list), but I wonder if I can use straightly the VALIDATION function.
TIA,
Thanks to everybody for your contributions.
As Master Yoda said: "Strange behaviour has ...!"
But, returning to the reality... what you mean with the problem could be FOXUSER? Every user get access to FOXUSER in the app path (just one for all...) I deleted the FOXUSER.dbf but not FOXUSER.fpt...
Thanks dbMark
Thanks rob444
Thanks tesar
I appreciate your contributions!
But still I think the problem is other than the ones you mentioned...
I know lots of people running Fox applications in XP with no troubles. Note tesar in Fox, not in Foxpro... I think it makes the difference... And in...
Hi Cricket, Hi Tesar:
Thanks for your attention.
I'm just getting mad with this trouble!
It's not a matter of copying files to anywhere, it's just openning certain files when the app gives errors (just in XP PC clients).
I've read some questions as mine in the net (in some forums), but I...
Hi everybody,
I'm using an application (written in Foxpro 2.5a) for years and it works fine under all OS Win I tried.
But now I've some troubles when running the app in a PC under XP: I don't know why but with some (not all) files if there's another user it gives a message "NOT A DATABASE...
What I'm looking for is a programm that enables the cursor reading any figure on the screen, in the same line, for instance, that when you point an icon in the desktop and it undrelines it and changes the title's colour.
Once I have read the figure I want to multiply it for a known number and...
Thanks John for you quick answer.
I'll try to apply although my question was more in the direction of read in any application running unther Windows.
Ramon.
Hi,
I have seen specific applications that 'converts' data "on-the-fly". That's it! You approach the mouse pointer to a figure and automatically it shows you the result of a prefixed conversion. If the data on the screen is 2.00 and my conversion factor is (x0.333) it will show 0.666...
I'm not able to print different fonts in the TM-U210 Epson printer although I have read the User's Manual one can find in internet.
I can't see how to apply in the Foxpro 2.5 DOS because using the usual commands @ prow(),1 SAY CHR(27)+"W1" (for expanded mode)does nothing, and I can't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.