Search results for query: *

JRB-bldr, I could use the suggestion using memlines if the case is for my address (max 4 lines).The thing is I want to use this kind of reporting with other memo field which the number of lines is unknown until the user type in the data. How are we gonna design in our report writer ? we cannot...

Stefan, The data that I have for my address is memo field type. So if someone type in 2 lines instead of 4 lines address, the report writer will not consider the third and fourth line as a blank line. Unless the memo is empty then it will consider as a blank line. So If I design 4 lines of row...

Hi all, I need to create a report which might look like this : Name : XXXXX Address : XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX City : XXXXXXXX Country : XXXXXXXX If the address is only 2 rows then city and country will move up 2 Rows (Label and field will move...

Craig Bernston, What I did is I store only ID Customer and ID Agent in order.dbf. Then I want to generate data using sql where the fisrt column is orderid, 2nd column is the name of the customer, then 3rd column is the name of the agent where both name is stored in one file called customer.dbf...

Dear All, I am trying to write a select statement with the following situation : Table1 (Order.dbf) Table2 (Customer.dbf)(For Customer and Agent) OrderNo C12 IDCust C12 IDCustomer C12 IDName C30 IDAgent C12 I want my sql result to be OrderNo IDName IDName...

SonOfEmidec1100, it seems that I my password is not set on myxp. When I create a new password I can connect successfully. Thanks for your info. Brgds Eng An

Hi all, I try to create a system dsn (odbc for sql2000) on my win xp but it failed. I got an error message like this : connection failed sql server error 18452 user not associated with a trusted sql connection I already setup user account and login account on my win2000 server and sql 2000...

Thanks Chris, I try your suggestion and it works. Eng An

Hi all, I Have a Grid with 2 columns. When I Press the Right Arrow key, my first column disappears. My 2nd column is shifted to the left and I got 3rd column with blanks. Is There a way to avoid my 2nd column being shifted so that When I press right arrow key nothing happen. I am using vfp8...

Hotfusion, I Try your suggestion point 2 and 3, know my install new font menu appears again. Thanks alot guys for your help. brgds Eng an

Hi all, I lost my install new font from the file menu (font window). Is there a way to make install new font menu appears again. I use win98 second edition Thanks Eng An

Hi, I like to close window msdos automatically. Is there a way to close window msdos program from vfp. here is mycode dosShell = CREATEOBJECT("wscript.shell") dosShell.Run(dosCmd,1,.t.) where dosCmd is my dos program when the program finish executing, the window is still...

remsor, I try my array public and it works find. The thing is if we have array public then we don't have to pass as a parameter. What I like to do is having local array then pass it to a function as a parameter. Eng An

Dave, I try your suggestion but it still give me an error when compiling. Instead I changed the code and got no error message. First Program DIMENSION myArray[1] Do whatever here... myUdf(@myArray) In the procedure file: FUNCTION myUdf PARAMETERS myArray EXTERNAL ARRAY myArray myArray[1]...

Mike, I think the problem is on my prg files. I have 2 prg files. 1 for the calling program dan the other is the function I called. When I put together into one file, I got no error message. Eng An

Stella, I try your suggestion and still got the same error. Mike, I still got the same error even I add SET UDFPARMS TO REFERENCE right know I use vfp 7.0 to compile my program. Mike , did you get any error message when you compile on your machine ? engan

Mike, I already try passing by reference and still got the same error. The exact error message is : Unable to find unknown myarray If I delete the statement myarray[1] = 12 and myarray[2] = 15 the error message does not appear. Eng An

Hi all, How do I pass an array to a function ? here is my code : LOCAL ARRAY myarray[15] myudf(myArray) FUNCTION myudf(myarray) myarray[1] = 12 myarray[2] = 15 ENDFUNC When I compile it , I got an error message. It says cannot find myarray. Eng An

I try it and it works. Thanks guys for your info. Engan

Is there a function in vfp to get the data from a field based on the field position instead of the name of the field. for example my field is : idnumber c 5 name c 30 balance1 n 17 2 balance2 n 17 2 balance3 n 17 2 fieldget(1) it will get the first field (idnumber) fieldget(2)...