Search results for query: *

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

If you TABLEUPDATE() the real table, execute the SQL again to reload the data in the working table and link it again to the grid. Take care of disconnecting the RecordSource before recreating the working table and connect (via code) the ControlSource for all the columns again because when you...

I'll try to be clearer. It's not a problem of hh:mm or mm:ss... it's exactly the same. Try to run form VFP SELECT "01:00" FROM your_table INTO CURSOR Query SELECT QUERY COPY TO C:\TEMP\F.XLS XL5 Replacing your_table.. so as to create a CURSOR which contains rows with columns with...

Ok, now it works fine. I still have the problem in applying the cell format date/time, but I know it's not a really VFP related issue... if someone knows something about or someone knows where I can submit this issue free (an expert excel site...) Monika, I'm 60 km north Milan - Varese -...

Ciao Monika ! How about the weather there ? Here is terrible hot ! Thanks for your reply but, I do not know why, the Close with parameters returns 'OLE error code 0x8002000e Invalid number of parameters'... I use VFP 6.0... do you think I could have problems in the Excel library installation or...

Try this. Create a method... we can call ChangeColor with this simple code : LPARAMETERS icFieldsState RETURN IIF(AT('2', icFieldsState) > 0, RGB(255,0,0), RGB(0,255,0)) In the DynamicBackColor of the column you want to modify call this method.. so ...