Recent content by tekytippy

I have a similar problem. When I load data into a non data bound grid class that I use, I want to prevent the user clicking on another tab on the form etc. Is there any way I can monitor keyboard and mouse input while the data is loading and not process it. I know when data starts and ends...

By simply putting some MESSAGEBOX statements in two events, the lost focus event of a text box and the click event of a dbi grid control I have determined that if a user who has currently got focus on the text box clicks the grid, this grids click event runs before the lost focus event of the...

This query takes over 3 seconds to run z_sales_unalloc[1] = 0.00 SELECT SUM(check_order_line_item.l_qty_unallocated); FROM check_order_line_item; LEFT JOIN check_order_header; ON check_order_header.h_order_no == check_order_line_item.l_order_no; WHERE check_order_header.h_type == "O&quot...

If you know sage data object (SDO) and have used fox to link with it. Do you know how to access sage's BYTE data type?

Keith Your suggestion of objHeaderData.type Throws up an OLE error and won't work. I traid all sorts of combinations and they only work as per my original example.

Keith Yes they were based on a VB Code example. I'll try your suggestions and let you know. Thanks very much.

How do we deal with an undefined data type. Can we use it?

Mike VFP7 SP1 My code works ok in the command window too. I must be doing somthing in my app to get this behaviour somehow? Rgbean All Files are on local computer.

However.... If I add a copy of the replace code and unlock after the first replace and unlock, the second set works. i.e. SELECT order_header REPLACE order_header.h_order_status WITH 'K' UNLOCK IN order_header && Gets Set Back To 'P' SELECT order_header REPLACE order_header.h_order_status...

I use an unbuffered table and make some changes to it. When the user leaves the screen I unlock the record using UNLOCK IN order_header. If I watch the debugger at this point a certain field contains 'K' but as soon at the UNLOCK IN order_header line runs it changes back to its previous value...

wgcs "for curiosity, find out what this shows: WAIT WINDOW TYPE( " loObj.VALUE " )" The answer is U. Is there any way we can convert it?

Hi This is the really confusing bit. This line also causes the same error "Function argument, value, type or count is invalid" lnType = loObj.VALUE I also put this line above the other line loObj = objHeaderData.FIELDS['TYPE'] In the debugger, I cannot on the loObj object...

This is the code I use to read the data from the TYPE field. This code fails on the first CASE statement with the error "Function argument, value, type or count is invalid" z_transaction_value = objHeaderData.FIELDS['FOREIGN_GROSS'].VALUE -...

Dave I will check more and get back to you on this. Thanks for the help so far though.

It contains a numeric value i.e. 1, 2, 3 etc but I have to use the Sage Data Object (SDO) to get the data and this is where I think the problem is happening as it is the SDO that returns the "byte" data type. I just don't know how I can convert it before VFP comes up with the error. I...