Search results for query: *

Hi! I have 3 buttons visible If I click Add button only Add button should be visible. Then If I click back the Add button it will display all But after I click it back the other button is not aligned. function addBank(polno){ var editbtn = document.getElementById("btnEdit")...

Hi! I have 3 buttons visible If I click Add button only Add button should be visible. Then If I click back the Add button it will display all But after I click it back the other button is not aligned. function addBank(polno){ var editbtn = document.getElementById("btnEdit")...

Hi! Can I position my form (frmchecks.scx) to appear inside another form (branch.scx) when the radio button is clicked? It works when I change the Top and Left but if I do this will it stay in the position even if the device changes? <-- changes depend on the radio button frmchecks.scx...

Hi! I'm trying to COPY TO aglib_aug24 TYPE XL5 file in a folder but the file name is already exists. Is there a way I can rename the file I'm about to save without changing the exitsing one. SET DELETED ON SET SAFETY OFF SET UDFPARMS TO REFERENCE CLOSE ALL CLEAR LOCAL...

Is there a LISTAGG code in foxpro9 or any similar process? Thank you for the response. :)

Hi! I would like to know if I can use merge with multiple executions when matched. When matched, it should insert the matched record into a history table first and then update the main table. When not matched, it will insert into the main table. I just wanted to back up the matched record for...

Hi! Is there a Merge Into in Foxpro 9 like what Oracle does? From my previous thread in my table, I already have duplicate records that I wanted to delete the old one and retain the latest as-of-date. So now instead of inserting all records at once, I wanted to check if the new record has...

Hi! I wanted to delete only the old records but I ended up deleting both. To get duplicate records I used having count(*) > 1 then Delete from region. SET DELETED ON SET SAFETY OFF LOCAL pcPopFile,pcCurrDir *---------------------------------- pcPopFile = "C:\BACKUP_FILES\NETPAY"...

Hi! I get an error "No table is open in the current work area" in highlighted part. SET DELETED ON SET SAFETY OFF LOCAL pcCurrDir,pcScrPath,pcBckPath,pcRegion,pcAsOf,pcBkDate,pnCtr,lnRegCnt,lnDupCnt,lnDelCnt,lnDupCnt,lnTotCnt *---------------------------------- pcCurrDir =...

Hi! I'm going to create a form that uploads a single .dbf file and use it as a table for extraction. Below is the form layout... textbox = disabled; views the file name uploaded Upload = should get the .dbf file in the local driver of the user Extract = after upload, extract the file using...

Hi! If remarks is not null... I'll have to separate UMA, AMR, and BAB in rows like below... Thank you!

Hi! I'm going to import a record into the database. RECORDS TABLE After I import I get this instead. RESULT The polno should be the same as records. How can I fix the inserted record? Thank you!

Hi! I have a set of names in a column. Is it possible to separate it from different columns using excel? Thanks!

Hi! I have a set of names. Is it possible to separate it from different columns? Thank you!

Hi! I have a column "character" that contains multiple names The result should be... thelaypig / thelaxypig / thelazypig Thanks for the replies!

Hi! I have an existing dropdown list then I want to use/get only 2 values from it to create another dropdown. Is it possible? or should I use it as an array? Suppose that I have another dropdown to determine what will appear in the claim type dropdown. dropdown in tpl <td...

Hi! I can consolidate a multiple .xls file to 1 .dbf file but what if that xls file has multiple sheets and I only needed that specific sheet? How can I do that? Thanks for the replies!

Hi! I'm creating an extract form where the process of the code is from a deped.prg. Here is my extract button code below... SET CENTURY OFF SET CENTURY ON SET DELETED ON SET SAFETY OFF SET UDFPARMS TO REFERENCE CLOSE ALL CLEAR LOCAL...

Hi! Is there a way where I can use the result from oracle select to another cursor select. To explain further... 1) I have a result.dbf file where will I insert the result of my selected queries 2) Oracle database Select 3) Foxpro Select from table 4) I have to use some of the data result...

Hi! Is there a way where you can cancel an ongoing program like pressing Esc to cancel it, or it is only on the task manager? Thanks.