Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Rogy
  • Order by date
  1. Rogy

    Problem with numeric data with SQLEXEC()

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

    Problem with numeric data with SQLEXEC()

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

    Problem with numeric data with SQLEXEC()

    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).
  4. Rogy

    Problem with numeric data with SQLEXEC()

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

    Calling .PRG within EXE

    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. :)
  6. Rogy

    Calling .PRG within EXE

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

    Calling .PRG within EXE

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

    Calling .PRG within EXE

    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!
  9. Rogy

    Optimizing a report

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

    Optimizing a report

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

    Optimizing a report

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

    Optimizing a report

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

    Which object has been "clicked"

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

    Which object has been "clicked"

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

    Which object 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...
  16. Rogy

    Error - EXE is not an object file

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

    Error - EXE is not an object file

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

    Problem with Xstandard.zip

    It works! Thanks!
  19. Rogy

    Problem with Xstandard.zip

    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")...
  20. Rogy

    DOS printing on HP LaserJet 1005

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

Part and Inventory Search

Back
Top