FiveTech Software tech support forums

I had not seen that other post. I have now and you are right my point becomes out of context. The good thing about that thread is that we can see how to slowly start moving to SQL until we become experts. That was my experience. I know many people ask --why? and the question is valid when your app m...

His question was about the behavior of our library. Whether after oRs:Delete() do we need to oRs:Skip() or not. That point is clarified. The point of using sql statement DELETE FROM <table> [ WHERE <cond>] was discussed in his other post. ...

... not saying anything new to anyone. On the example in this thread, instead of traversing the complete table checking for eof(), you would do this: DELETE FROM <tablename> ;   Suppose you want to extract certain records from the table based on certain condition. With our traditional ISAM you ...

Thank you Master !
Maurizio Menabue

Code: Select all  Expand view

oRs:gotop()
do while .not. oRs:eof()
    oRs:delete()  <----- the pointer on next record ?
enddo
 

Yes.

Hi all when you execute the delete command is also done skip ? oRs:gotop()do while .not. oRs:eof()    oRs:delete()  <----- the pointer on next record ?enddoor old way with DBFoRs:gotop()do ...

hi all is it possible to completely delete a datarow with a single command if so which one?    LOCAL oRsDel AS OBJECT   LOCAL cSql    AS CHARCTER       cSql := ""   cSql ...

Mr. Rao: Thank you for you help. I have checked and there is no situation like the one you mention, in fact there is no DELETE code Above you can see all the code and all the error.log file. the first time I enter with the empty table, the two records are added , one input and the ...

... its applied formatting as they edit. The features and capabilities of the RTF edit control in FiveWin may include: Text editing: Users can enter, delete, and modify text within the control. Text formatting: The control allows applying formatting options such as bold, italic, underline, strikethrough, ...

... DateStart to DateEnd so you do not need 2 x DTPICKER p.s. as CLASS TCALENDAR seem not "hardcode" somewhere else you can make a copy and delete METHOD HandleEvent()

hi thx for Answer. after read in your CODE i insert   oBtn:Hide()   oBtn:destroy()  // => End() now it work :) but i see no reason "why" it does not work without oBtn:Hide() ... hm ... :? hm ... are Button "real" Destroy :idea: i have add to 2nd Button   MsgInf...

Hy Jimmy. Look this: #include "FiveWin.ch"#Define CLR_MSPURPLE   nRGB( 0,   120, 215 )#Define CLR_MSRED      nRGB( 232,  17,  35 )#Define CLR_MSGRAY     nRGB( 229, 229, 229 )#Define CLR_LGRAY      nRGB(...

hi here is a Sample #include "FiveWin.ch"#xtranslate END WINDOW          => // END WINDOWSTATIC nBB           := 30STATIC aBtnDrives    := {}MEMVAR oMainPROCEDURE Main()LOCAL oBtnPRIVATE oMain   DEFINE WINDOW oMain FROM 0, 0 TO 600, 800 PIXEL TITLE "FiveWin DriveB...

hi, i have Button for each Drive https://i.postimg.cc/NfL1nyJG/Drive-Button.jpg when add / remove USB Drive i want to "End()" BTNBMP and create new depend on Drive Letter oMain:bOnDeviceChange := { | o, w, l | OnDeviceChange( o, w, l ), oMain:Refresh() ...

Hello,

I'm very sorry but I might have asked this question before. Unfortunately I can't find it anymore.

But can someone tell me how to add or delete lines in an Excel worksheet?

Thank you very much in advance for any help.