Search results for query: *

Hello Forum I have two formulae for report variables in sequence in Report Properties: IIF(flowtypeid = 8,amount,0) and IIF(flowtypeid = 6,amount,0) . The first outputs a non-zero amount, the second outputs 0. The records have non-zero values for flowtypeid = 8 and flowtypeid = 6. Do you know...

Hi Forum I want to set up the application so that only an executable with a specific version number is allowed. If another executable is copied into the application folder but the version number differs from the legitimate executable the execution is aborted with an explanatory message if it is...

Hi Forum good evening. Please help me figure out what is happening here. If I run the database backup Stored Procedure in the query window using: exec [Sundries].[MCRevenueBackupSP] "C:\Marshall\" it completes ok. If I run the FoxPro SQL Pass Through it doesn't complete successfully. The...

Hello Forum: I want to convert oGv.pnBurialPlotId = 'transtab'+ALLTRIM(STR(lnReturn-1))+'.'+'burialplotid' to the format oGv.pnBurialPlotId = transtab.burialplotid. How is it done? The code I have doesn't work. I have tried it several ways. The result I get is in quotes...

lnMarketid = 0 lnReturn = SQLEXEC(oGv.pnConnhandle, 'EXEC MCRevenue.Sundries.RetrieveMarketRevenueBankTransactionsSP ?lnMarketid','bankingtransactions') IF lnReturn = -1 =odbcerror() && Log the error RETURN .F. ENDIF The 'comments' field in the table is 255 characters...

How do you put a password to the Bullzip email attachment for the individual. The MAPI session Id carries a password. In Bullzip PDF Printer Options you can set up an owner/user password. How would set up this in the FoxPro email routine. The password could be the social security number for an...

How can you send data directly to an Excel Template through code (without copying and paste)? See template attached.

The value for the date picker is in the form: ldDatepicker._value (underscore follows the period)

I got the following code from Marcia Akins et al cntMapi class which I modified to send PDF document by email. The client uses Outlook and would like to change the Default Email Account in the FoxPro code without employee intervention and back to the original at the end of processing. I want to...

I need to display the last occurrences of Personid from the table using a query. Table - ordered by employmentid EmploymentId PersonId BranchId HireDate 12 23 24 2019-04-21 15 23 24 2019-06-21 18 23 24 2019-09-26 21 23 24 2019-10-05 22 17 24 2019-02-21 24 13 24 2019-02-21 25...

What is wrong with this statement: lnResult = SQLEXEC(oGv.pnConnhandle, 'EXEC ClientSecurity.UsersCloneSP','userz') The stored procedure is qualified by a database schema name. Do I have to further qualify the stored procedure? EXEC ClientSecurity.UsersCloneSP executes successfully in...

What is wrong with this statement: lnResult = SQLEXEC(oGv.pnConnhandle, 'EXEC ClientSecurity.UsersCloneSP','userz') The stored procedure is qualified by a schema name.

Hello again MVP's Carolx seeking your assistance. I use Outlook to send PDF payslips to employees. The procedure works on both 64 bit and 32 bit computers but not on all computers. For some you get the message 'MAPI is not registered on this computer.' even though it is registered. What could...

Hello MVP's Carolx seeking you assistance. I have been trying to create a cursor dynamically using field values from a single column table without success. Please see example coding below. *> Field values in table empfld for this example are Casual, Holiday, Temporary, Permanent...

Hello Forum, I have a form with 8 parameterized cursors each set to no data on load with the same parameters. One of them is displaying an empty query in cursorfill. Why is this? If I remove the no data on load the program complains that the alias does not exist.

Hello Forum. I haven't had any problems before using cursoradapter. But now I have this form (page) where the base table is not being updated. I created a similar one-page form with the same fields using the same cursoradapter and everything works fine. What could be the problem? Both forms uses...

If I log on to SQL server from the Server via a shortcut from a local computer on the network and run the script below which computer name would be displayed - the Server or the local computer: DECLARE @uid INT,@loginname VARCHAR(70) select DISTINCT @uid = uid,@loginname = loginame from...

I have a routine that emails employee payslips. If I send the payslips as text file each employee receives the correct payslip. I set up the routine to send the report to Bullzip in order to create a PDF attachment. Now some employees are getting the payslip of another employee and it is the...

How do you bypass the 'Save the file as' dialog for an XPS document by assigning a default name to the XPS file. Can you assign a default name to the XPS file?

How do you pass information message to Visual Foxpro from SQL Server via CursorAdapter without using RAISERROR? Uses ODBC.