Search results for query: *

Mike, Thanks. Let me give this a try. Thanks again.

Hi, I want to create a connection to an oracle database through code. I am able to achieve this using a DSN. Is it possible to create a connection string that refers to the database directly, without using a DSN? I am using Oracle 9i and VFP7. This is how I am creating the connection string. It...

Mike, Thanks for your advice and insight into the issues I had. Let me digest your answers and see what I come up with. Incase of any other question, I will post it again. Thanks. Phita.

Hi, I am working on an application with tables having millions of records. I intend to upsize the database to MSDE2000 that comes with VFP7. My questions are: 1. Does the speed of data retrieval using a remote view depend on the speed of the underlying database? And if yes, which among...

Hi, I have installed MSDE 2000 that comes with VFP7. How do I use it to create databases? All I get is an icon in the windows taskbar. When I double-click on it, it just opens a form where I start or stop the service. I am running it on Windows 2000 Server. The earlier version of MSDE (version...

Thanks all for your help. Phita.

Hi All, The whole concept of views for SQL database is new for me. I have read a lot about but still have a problem with it. I am converting a network application, which worked nicely in the past with VFP database and tables to SQL tables with views. I have a transaction table of 1 million...

Hi, I am using Crystal Report 6. Is there a way of passing variables declared in my form to a report. I use the variables to determine, e.g. report headings, plus other information I may want to display on the report, depending on what options a user selects on the form that calls the report. I...

Hi all, I am a newbie to crystal reports. I am using ver 6.0. I have a form where a user enters the reporting parameters, e.g. date from, date to, account from, account to. How can I use these parameter in the report? Thanks. Phita.

Thanks Ramani.

Hi, Where can I get a good class/code to convert a number to words. I you have any such class/code, I would appreciate if you help me with it. Thanks, Phita.

Hi, I am using local views. I am often get this error message whenever I issue a TABLEUPDATE. What could be the cause?

I haven't tried this. Lemme go and try it and then I will come back to you. Thanks.

Hi, I have even tried to GO TOP after the deletion. However, when I navigate through the view, I get the record still there. But if I browse the table, the record appears deleted. Thanks.

Hi, I am using a local view to access data in a table. I have a form where I create records, with navigator buttons. However, whenever I delete a record and then issue a TABLEUPDATE(.t.), the record still appears in the view. However, if I check in the parent table, it is marked for deletion...

Hi Mike, Thanks for coming to my rescue. I will do as you suggested. Again, thanks. Phita.

Hi, I am creating an app using local views, to be upsized to remote views later. Now my problem is, how do I SEEK for a value in a view? Do I have to INDEX the view every time I load the form? Is there a better and faster way to do a search without using LOCATE? Thanks in advance. Phita.

Hi, "When you do updates are you changing any primary key or candidate key values in the underlying table?" I am not changing anything in the table directly. I am using the view to do the updates, e.g. add new record, delete record, e.t.c. The above error messages appear even when I...

Hi All, I am using a local view to access and update data in a table. However, when I try to delete or update a record in the view I sometimes receive one of the following messages: 1. Update Conflict 2. No key columns is specified for the update table "Mydata!Myfile". Use the key...

Hi, I have tried to "use" the .scx but it still tells me "Not a table". What else do you suggest I try. Thanks.