Search results for query: *

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...

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...

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.

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?

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, 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 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 was working on a form and my computer 'hang' and I had to reset it. When I came back to the form, I try to modify it, it tells me "Not a table". How can I fix this problem and recover the form. I had done so much on it I can't imagine starting all over again. Thanks

Hi, I want to start a new project and the client insists that the application be web-enabled. Please tell me exactly what a web-enabled app is and what it involves. Can I create it using the VFP IDE, i.e. without using a web browser as the user interface? Thanks

Hi guys, One question please: Which is the best & fastest technology to work remote data? SQL Passthrough or ADO? Thanks.

Hi, Which is the faster when working with remote data, say SQL Server: SQL Pass-through or Remote Views? I am about to start a new project and want to know the facts so that I can decide which method to use. Thanks.

Hi, I am having a problem with reports. When they run on some computers, they show *** on numeric fields while on others they show the figures correctly. How do I make the report printer independent so that they show correctly on all computers, regardless of the default printer on that computer...

Hi, Where can I get Crystal Reports trial version ? Preferably the one with drill-down feature. Thanks.

Hi, I know drill down is a feature that every client would wish to have incorporated in reports. Please tell me which tools/report writers that you use to give this feature to your reports. Whereby when you are previewing a report, you can click on an item to get more information on that...

Hi, How is the drill down feature implemented in Crystal Reports? Is it the one whereby when you have a report preview, then you can click on an item to popup another window with more detailed information, like the one in QuickBooks. Please advise further. Thanks.

Hi, I am having a strange problem with reports. When printing a report that is more than 1 page, the printer prints the first page and then stops. If the report is one page only, it prints only part of the page and then stops. Any ideas what could be wrong? The problem occurs in both Win95 and...