Search results for query: *

It is like this: I've tried your version, then I tried with: SELECT [Code], [Unit price], CONVERT(numeric(20,2),CONVERT(decimal(38,20), [Unit price])) as Unit_Price1 FROM I also tried with CAST(), then all with VFP 8.0 and 9.0, but the result is not OK. It is obviously VFP issue, because SQL...

TRANSFORM is VFP function not an SQL one. So: SELECT amount, CAST(TRANSFORM(amount,"###,###,###.##################") as n(20,18) doesn't work. The (59,18) is also too long for VFP.

Hello I've tried with this function, but still don't get the result I want. I need decimal value, with decimal places. I tried several combinations with CAST and CONVERT, but insted getting the value 2878,00 i get 2,88 (!?) The SQL data is decimal(38,20).

I am having problem with retreiving numeric data from SQL. In VFP8 I have: SQLEXEC(anav,'SELECT [Code], [Unit price] FROM [ZCDatabase d_d_$Sales Price]','curs1') The field 'unit price' is decimal type on SQL Database, but in VFP cursor I get N(20,20) type! Is there a way to change format of...

Thanks Mike...! Now It works as I needed. P.S.: Yes, the first question was strange... Sometimes you think one thing and type something else. :)

Andy I tried as you wrote, but it didn't work. - I added "PARAMETERS lpar1" in Main.PRG - rebuild the project(EXE) - RUN in BAT file as you wrote The application runs, but nothing happens.

I should be more specific. :) I am not calling PRG from VFP, Mike. I want to call it from Task Scheduler in WinXP. PRG is inside EXE. It should be something like that (I think): RUN Program.EXE with "prg1.prg" P.S.:I am using VFP 8

I have a program compiled in EXE that should be run once a day. Is there a way to call program file within EXE? Thanks!

Jim, Interesting tip, but I can't manage to get it work. If I use fixed picture, it is displayed only once per page!?! But if I use my picture from table (the path to the picture is in the table field), nothing is displayed. I've streched picture from detail band, over the group footer band. Rogy

Mike, I'll try this... i just hoped that there's a sollution with report designer. Thanks, Rogy

Yes, there are multiple detail records per picture. I've tried to put picture in the detail band, and in the "Print when" properties of the picture i've set "not" to print repeated values. The picture is show only once but on the right side I have gaps between two text records. How should I...

I have a report that shows picture of an article. I managed to do report like this: (in the group header is the picture and in the detail band is information (text fields): ----------------- | | | Picture | | | |...

It works! I've put Borislav's code in the Pictureclick event: AEVENTS(laEvents, 0) IF PEMSTATUS(laEvents[1,1],[Name],5) obj_name=laEvents[1,1].Name thisform.x_textbox1.Value=EVALUATE("thisform."+obj_name+".tag") thisform.x_textbox1.Valid ENDIF A star for you! Thank you all for...

I have tried with THISFORM.ActiveControl and AEVENTS() but still can't get the name of the object (which has been clicked)

I assigned a code to a click event of an object which I create programmaticaly. This object is a picture. There can be up to 6 of this objects. . . . thisform.AddObject(i_pic,"Image") WITH EVALUATE([thisform.]+i_pic) .visible = .T. .width= 84 .height= 84...

Don, I've tried to put the DLL-s into the WINDOWS\SYSTEM folder ant also into the folder with EXE file. I was thinking that EXE could be corrupted but it works on other two computers. I also thought that there was a problem with DLL-s so I copied them again, but error stays. This is the list...

I have made a simple application in VFP8. I have run this application on two computers (WinXp and Win98SE) an it worked fine. But now i want to run this application on third computer (also a Win98SE) and i get an error message: App1.EXE is not an Object file. I have used all necessary DLL-s...

It works! Thanks!

I've downloaded Xstandard zip component from http://www.xstandard.com/ I want to see(just see!) the list of files of archive. This is the example from their site: Dim objZip, objItem Set objZip = Server.CreateObject("XStandard.Zip") For Each objItem In objZip.Contents("C:\Temp\images.zip")...

I have similar problem with this printer. I can print from command prompt. For eg.: ' copy autoexec.bat lpt1:' - I get the result on the printer but it is al in a big size font! This is big problem for me, as I want to print from DOS application. Hp1005 has separate driver for DOS and WIN98...