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)

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.

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??