Search results for query: *

Dear All, I have two cursors like the ones below.tt1 and tt2 Index Col01 Col02 ... col164 1 Data01 Data03 ......... 2 Data02 Data04 ......... Index Col165 Col166 ... col324 1 Data01 Data03 ......... 2 Data02 Data04 ......... I want to insert them into the one SQL table(Items) using...

HI All, I Have a table like below, EmpID Name Salary Department I want to find the employees in each department who earn more than average salary in that department. How to write this query in SQL. Please help. I'm new to SQL Programming. I tried the below query but it did not give the...

Can anyone please explain to me what the IIF() function is?

I used Getfile() file function to get Excel file when I click button X = Getfile('xls', 'Please Select The XL File ', 'Browse') I want to know how to check if uploaded X's file type is one of the below. (*.xls, *.xlsx, *.xlsm, *.xlsb)

Thank you Mike and Chris When I used the AERROR () function, it returned error No 1526. [sadeyes]

The return value is -l, But I can't find any issue with the above code [ponder] Thank you

I tried the below code also from the Microsoft website. LOCAL lcXLBook AS STRING, lnSQLHand AS INTEGER, ; lcSQLCmd AS STRING, lnSuccess AS INTEGER, ; lcConnstr AS STRING CLEAR lcXLBook = [C:\GENERAL\AB.xlsx] lcConnstr = [Driver=] + ; [{Microsoft Excel Driver (*.xls, *.xlsx...

Chris Miller , Thank you for immediate response . I used the 2nd method(Microsoft.ACE.OLEDB.12.0 oledb provider and cursoradapter). I want to directly show my data in a cursor, not a memo field. How can I do this? Please help Thank you.

Chris Miller , Thank you for your code; it worked for me, but the some data fields in cursor shows as MEMO FIELDS. How can I fix this? please help! thank you.

I have an excel sheet as I drafted below. I want to get the above Excel Sheet data to Cursor. How can I do this in FoxPro? Please help.. Thank you. bashi.

Thanks Mike for the immediate response Helps a lot..

Chriss, Thanks for the reply How to call a method ? If I provide only the method name is it fine ?

I have a option group(3 radio buttons]) as below. A B C I want to call the method declared before when I select each option. As an example, when I choose option A, method A needs to be called. I want to write a Do Case for this scenario . How can I do this in FoxPro? Thank you

I have a grid as Grid1 and the columns are as below. Code Qty Delivery MODE 520B 100 521B 300 522B 500 I want to add a combo box to the Delivery MODE column to select one value from the Delivery MODE list. How can I do this? please assist me...

I have a grid as Grid1 and the columns are as below. Code Qty Data 520B 100 02/05/2022 521B 300 02/05/2022 522B 500 02/05/2022 I want to clear the grid data when I'm click on the clear button. how can I do this??