Search results for query: *

I need to be able to pull data from a sql database for month to date and last full months data. I'm having an issue with date time. Here's an example of the sql where clause: Where (((dbo_RMS_Roll30DAY_SALES_EXCH_DLY.TXN_DT) Between (Select FetchStartDate From FetchDateTable) AND (Select...

I'm running a function that should pass dates to a table. In the following example the variables debug as MyDate1 = #12/1/2004# and MyDate2 = #12/31/2004#. When they load into the table they both load as 12/30/1899. Does anyone know what's going on here? Public Function FetchDate() ' Function...

I'm getting an error: "Function isn't available in expression in query expression 'dbo_RMS_Roll30DAY_SALES_EXCH_DLY.TXN_DT between date()-7 and date() and dbo_RMS_Roll30DAY_SALES_EXCH_DLY.DRCT_FLFLL_FLG = 'n'". If I remove the date() it returns data. Thanks!

I have a query that uses on database to update another. The one that is updated is password protected. The problem comes when the query runs on the first database it prompts for a password. Since the whole idea was to automate the updating of the second database this will not work as designed...

I've written the following pass thru query to a SQL database. I need to pull data from 3 days ago. The SQL date field is a datetime field and the query is pulling way too many records. Is there a way to convert the date in the pass thru query? SELECT a.TXN_DT as date, a.ORD_NBR as ordno...

Here's the issue: I have two tables that are joined by the ord_nb field. The primary table has a field called sku. My customer wants to join an Excel spreadsheet that has a list of sku's to the tables. They want to see all of the sku's that are on the primary table but want the sku's that are...

I have an issue sending an email in Access. The code is running on a server as a schedueld task. It all works fine until the code try opens Outlook 2002. At that point a message box appears that asks for the outlook profile ("choose profile"). It defaults to the company profile and when I click...

Does anyone know how to get the last day of a month in Crystal 8.5? I have a date field and I need to get a percentage using the amount of days in a given month. Thanks!

I have had to change several Oracle table field lengths and types from CHAR to VARCHAR(2). I ran a rtrim on all of the tables and fields in Oracle after the change. The problem comes when I pass the table structure from Oracle to VFP (see below). local array laField[1] aFields(laField...

I would like to see if Visual FoxPro 7.0 will allow me to write an auto start CD that will open MS explorer and take the user to a specific web site. Does VFP 7 have this capability? Thanks

I loaded a project in VFP 6.0 that was built with VFP 5.0. When I tried to go back to VFP 5.0 I got an error message "cannot open project file". I remember reading somewhere that VFP 6.0 adds something to the project file and all you have to do is remove it. The problem is I'm not sure...

I would like to call a DLL from a FoxPro Procedure. The procedure is in a do while loop. We are running a FoxPro 7.0 front end to a Oracle 8.1.7 database back end. I need to call the following using VB: if sqlExec(connectionHandle,lcSql ) < 1 handleError( program(), lineNo( 1 ), .t. )...

I'm testing an application using VFP 7.0 and windows 2000. In VFP 6.0 and windows 2000 the copy and paste function work perfectly. Using VFP 7.0 is does not work at all. I removed (un-registered regsvr32 /U) the VFP6R.DLL and VFP6RENU.DLL and replaced (registered) the new VFP7R.DLL...

In version VFP 6.0 I was able to rename, add, and drop columns of cursors. It doesn't seem to work in VFP 7.0. I use the cursor data in exported excel files. Does anyone have any suggestions? Sample: ALTER TABLE tmpPayments DROP COLUMN acctg_dt ALTER TABLE tmpPayments RENAME COLUMN Idate TO...

We recently upgraded to windows 2000 5.00.2195 SP 2 and have been getting the following exception code error C0000005. So far the error has been trapped and the call chain ends when the code hits: if sqlExec( gnConnectionHandle, lcSql ) < 1 handleError( program(), lineNo( 1 ), .t...

I've included the whatsthisButton (as .t.) on several forms in a VFP6.0 app. When the min and max properties are set to .t. the whats this ? mark will not show up on the form. If I set the min and max to .f. it shows up and works properly.