Recent content by LALLORA

Hi all. I use Crystal Reports 8.5 and Visual Fox 6 (but I'll move to the version 9 soon). I need to print a document where, besides the code and product description, I have also to print the product's photo. For each photo I stored, in a table, the full pathname of the file. The user selects...

Yes, I'm trying to find an already existing object but not only a 'bridge' to VFox but an object which, for example, optimize the search choosing a SEEK instead of a SELECT when possible, allows me to manage multiple updates in only one transaction so as to get all things written or all...

Hi all. I'm trying to find a (VFox) COM object which allows me to read any table, simply passing the proper parameters, I mean, a COM object I can call from Java, for example, to read a VFox dbase so as to create a Java application which read the data from a VFox DB. I do not want to use an...

Yes, this thread is duplicated. Sorry. Thanks for the reply.. I'll try. Marco (Italy) marco.dicesare@elmec.it

Hi, I'm not expert in VB.NET programming and so I'm facing this problem. This is the code, coming from VB6, which highlights an error: Public const posblk_len as short = 128 Private posblock as new VB6.Fixedlenghstring(Posblk_len) the definition of POSBLOCK returns a 'type not defined' and an...

Thanks for your tek-tips ! I replaced all my ON KEY LABEL with the code in the KeyPress event and it works. I left te F10 ON KEY LABEL because users want to use this key to confirm the input (AS/400 key ?) and F10 is a reserved key that KeyPress is not able to capture... if anyone nows how to...

Ok I found the way. In the Save function I added the following code to check if in the program caller stack a VALID method was called : * Check for all the nidification levels FOR lnCaller = 1 TO 128 lcProgram = SYS(16, lnCaller) DO CASE * The stack pointer points to myself CASE...

Unfortunatly I must jump out from the field so as to validate/format it before save the data. I could be in a grid field, in a spinner field... everywhere. Thanks. Marco (Italy) marco.dicesare@elmec.it

Further info. I interviewed the user and he told me that when the cursor is into a field he presses ENTER and F10 in a very very short time. I told him not to do so as to avoid the error but the problem exists. I cannot issue a PUSH KEY CLEAR and POP KEY in each VALID method for each field in...

Hi all. I've this problem. In the MAIN.PRG I use ON KEY LABEL F10 xfnClickSave() where xfnClickSave() is a function which moves the Focus to the SAVE button and performs the Click() method. This allows the user to press F10 to save the data. Now all works fine but, sometimes, I get this...

Usually I put the views into a database and I create them using the CREATE SQL command. In this way, when you create the view the login to the Oracle DB is requested and the fields properties (type, length...) are automatically created by the CREATE SQL command matching the Oracle properties...

OK.. but pay attention that VFP numeric 14,4 is 9 integer pos. + separator + 4 decimals ORACLE numeric 14,4 is 10 (!!) integer and 4 decimals This was the reason why you had the problem. Marco (Italy) marco.dicesare@elmec.it

Are you sure that the Oracle field is a numeric field... this because, usually, even though your field contains a number with only 1 significant decimal number (i.e. 56,7) if the field has 4 decimal places, all the decimal places are showed... so 56,7000... in you example firstly only 1 decimal...

Ciao, I developed using VFox and an Oracle DB and I didn't have this problem... can you paste here your remote view creation script and the Oracle DB creation script.. I could check them... here two of my scripts (the VAT_PERC field is correctly read) : VFP view CREATE SQL VIEW vVAT REMOTE...

Ah ok, if your working table is not a temporary working table things change. So back to Mark answer... did you TABLEUPDATE your working table ? If you use a table buffering you must TABLEUPDATE the table so as to FIX the data into the table. Marco (Italy) marco.dicesare@elmec.it