Recent content by Rogy

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