Search results for query: *

Carolx Programmer How about sending emails using Outlook Automation with Bullzip printer for PDF attachment. I was using the Mapi protocol to send pay slips by email but it is not working with Windows 11. I kept getting the message 'Mapi is not registered on this computer'. ChatGpt suggested...

Sorry I didn't give up. I had to leave. I will look further into the suggestions and if I come up with a solution I will post the results. Thanks very much for the assistance.

The problem is not crucial. They can get the variance at the end of the report by subtracting the outflow from the inflow or vice versa. I just wanted to include it on the report.

IIF(flowtypeid = 8, amount, IIF(flowtypeid = 6, 999, 111 )) flowtypeid = 6 still evaluates to 0. (flowtypeid = 8 is ok)

The variables are ok on the report form. The flowtypeid is evaluating correctly for the inflow but is outputting 0 for the outflow even when I use this formula: IIF(flowtypeid = 8, amount, IIF(flowtypeid = 6, -amount, 0)) for the variance.

It is a cash flow program, inflow and outflow records. The Id for the inflow is 8 and for the outflow it is 6. The variable name is flowtypeid. The report variable is used to determine the variance at report end (inflow - outflow)

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 use the expression x = AGETFILEVERSION(arrVersion, "vpay202410.exe") to determine whether an upgrade is due, whether an outdated executable is being used, and whether the name of the executable has been changed, as Mike had suggested. Thanks for the suggestions.

An executable, tpay24.exe, can have different versions. What I meant is that if someone copies an older version in the application folder it would overwrite the current one of the same name. Mike, What I want to find out is what the latest version number should be - perhaps by reading it from...

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

It was a database permission problem. I included doing backups from task scheduling. Thanks for the suggestions. Carolx

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

This is a part of the stored procedure: @BurialPlotId INT, @Returnvar INT OUTPUT BEGIN TRANSACTION SELECT * FROM Burial.TransferGravePlot (HOLDLOCK) WHERE burialplotid = @BurialPlotId IF NOT EXISTS(SELECT * FROM Burial.TransferGravePlot WHERE burialplotid = @BurialPlotId) BEGIN SET...

Chris I tried it again. laAliases[lnI] -> transtab (lnI = 1) laAliases[lnI] -> 0 (lnI = 2) laAliases[lnI] -> transtab1 (lnI = 3) but it is outside of the loop

The stored procedure returned two result sets: an empty cursor and a cursor with one record and two fields: burialplotid and transferdate. I tried Mike's method but it didn't work. I also used Chris code and got 'table number is invalid'. What I did eventually was to set step and display 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...

I have tried different approaches but haven't come up with a solution. What I did eventually was to decrease the width of the comments field. I am still interested in the solution though. If I come up with one I will post it.

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.