Search results for query: *

Hi Martylb you can use the below sql statement for what you need alter table tablename rename column colname to newcolname HTH [smile] gchandrujs [sunshine]

Hi, . So in case there is a poweroutage during the insert process I don't have bad data For that you have to use Transactions or Buffered Tables. BEGIN TRANSACTION SELECT statement... into Cursor Mycursor select Mytable Append from DBF('Mycursor') END TRANSACTION If the power short comes in...

Joe How can i disable the next button when i navigate at 20th record and disable the previous button when i at first record? In the Next Button add SkIP If Eof () SKIP -1 THISFORM.REFRESH () THIS.ENABLED = .F. ENDIF Use the same accordingly in the PREV button. To Enable the Same in the...

Hi Joe, Since the Record pointer in the Beginning & End of the File the controls looks like disabled. So, Use the following conditions before navigating in your command buttons. *** IN THE PREV BUTTON IF NOT BOF () SKIP -1 ENDIF ** IN THE TOP BUTTON IF NOT BOF () GO TOP ENDIF *** IN THE...

Hi, Try using KeyPress Event. But even for Cursor movements between the contents in the combo box this event fires. Otherwise try using VALID event. gchandrujs [sunshine]

You have to give either TABLEREVERT(.T.) or TABLEUPDATE(1) to come out from this problem. [smile] gchandrujs [sunshine]

Dear Mike, Hope you too understand that FreddyHo may use more than a table for Packing slip too or however if a Invoice may contain Multiple Packing slip It may be not possible to do this in Summary Band. Because In general, he may need just like another Detail Band. This is my lowest...

Hi, According to me, it is not possible But can be done in some lengthy way and it should not be faster as you think. So, it is good that let it be in 2 reports. In your programming make the output (preview) of the 2 reports continuously. ie.. REPORT FORM MyInvoice PREVIEW REPORT FORM...

My Heartiest Congratulations Mike You have helpmed me in many ways and i am remember you always and Many many thanks for your help. [b]Once again wishes to grow in your life,and hope your help continuous to everybody forever [b]Praising the Lord to Bless you[u] GCHANDRUJS [sunshine]

Hi, As you told, if you select the rowsource type as "cursor1". Then after in the Refresh Event of the Cursor you write the following. thisform.grid1.setall("VISIBLE",.f.,"Column") THISFORM.GRID1.COLUMN1.VISIBLE = .T. THISFORM.GRID1.COLUMN4.VISIBLE = .T. The...

Hi, As you told, if you select the rowsource type as "cursor1". Then after in the Refresh Event of the Cursor you write the following. thisform.grid1.setall("VISIBLE",.f.,"Column") THISFORM.GRID1.COLUMN1.VISIBLE = .T. THISFORM.GRID1.COLUMN4.VISIBLE = .T. The...

To make Generic / Text only, When you install New printer instead of selecting the Exact Manufacture from the list during install, Select GENERIC under Manufacturer list and GENERIC / TEXT only under Models List. This will Helps. If you don't want to reinstall the printer, From the Printer...

HI Mike, Where there is need, we have to use somethings. What cjulio done with Where &comando is not wrong. He may in need of that. I can't understand And see if that is the culprit Suggestions Invited... gchandrujs [sunshine]

I Think that SQL query Statement takes long time and ATCC too. If you want to know the timings of each line execution try using SET COVERAGE TO filename command before executing the above codes and after finishing codes give SET COVERAGE TO. Now you can view the filename for time taken for...

HI, to add seconds you use give as follows. eg. ?datetime () ?datetime ()+ noofseconds If you want to add a minute ?datetime ()+60 If you want to add an hour ?datetime ()+3600 && (60 Mintues ie. 60 seconds x 60 minutes) Suggestions Invited... gchandrujs [sunshine]

HI Poeijer, If you found any problem with Mike's suggestion, go to the following. FOR I = 1 TO _SCREEN.FORMCOUNT IF _SCREEN.FORMS(I).NAME = "Yourformname" _SCREEN.FORMS(I).TEXT1.VALUE = "TEXT2" ENDIF ENDFOR Anyhow you are not going to run more forms at a...

Ya, that i know why you gone to interactive change mode. Your approach is good but If it is List box no problem As you are using grid there will be delay in time. Anyhow, you create a seperate method which contains the No. of Columns, column widths of the grid, Header captions etc., and in the...

HI, select myCode ; from zz_test ; WHERE myCode LIKE ("%"+UPPER(ALLTRIM(Thisform.text1.text))+"%"); into cursor myCursor After that put THISFORM.LOCKSCREEN = .T. THISFORM.GRID1.RECORDSOURCE = "MYCURSOR" THISFORM.LOCKSCREEN = .F. The above results appear in grid...

HI VFP602, You told that the option group is bounded with Character field. So follow the below. Make the value property of one option button as 'AL' and other option button as 'SL' in the option group. And make the option group value property as either one of your value. Hope the above...

Kenndot I'm trying just to get out of the program altogether when an error is generated As you told when error occurs what are the option buttons that are available with that error. whether CANCEL,SUSPEND,IGNORE, HELP. Check it? this may cancels your program execution further after the...