Search results for query: *

Hi there. Are you definitely tied to using the @...SAY command? I haven't got my manual handy but isn't there a clause for COLOR or RGB for the @...SAY command. Anyways that is pretty old way of doing this you may wish to consider the methods below: You could use a label or text box to...

Thank You SEM!!! Success at last. This has been a tough one and I've been using many resources attempting to find something that works. This did the trick. I owe you a beer! Peter

This helps a bit JJ. I looked into ORACLE a bit and the Stored procedure name needs to be preceeded with the EXEC command. ORACLE also accepts EXECUTE. I've tested out running the stored proc from SQL*Plus this way and it works fine. But I still have a failure in FoxPro when running either of...

I've already posted in the VFP forum and was lead here. Thank you in advance for any help. I have an ORACLE database that I'm hooked to via VFP 6.0 I can create remote views or use SQLExec() to fire off pass-through SQL statements against the ORACLE tables. I need to trigger/execute some ORACLE...

I have an ORACLE database that I'm hooked to via VFP6.0 I can create remote views and use SQLExec() to fire off SQL statements against the ORACLE tables. I need to trigger/execute some ORACLE stored procedures from a VFP program. I've tried this: Note that the stored procedure is called...

If you have this field indexed, then skip the SQL and just do this: SELECT tablename GO BOTTOM MaxVal=ldudetail.UniqueId If it's a DESCENDING index then substitute GO TOP for GO BOTTOM. This should be instantaneous. Peter

I've used FP 2.x for years but am fairly new to VFP. I have my ODBC drivers in place and an ORACLE database and VFP 6.0. How do I run a simple SQL statement from the VFP command line against the ORACLE table? I assume I'll need to open a connection to the db... but how (I have a host name, db...