Search found 493 matches: limit

Return to advanced search

Re: Ejemplo xBrowse-MySql?

... "+ cSelect + " FROM "+oTabla+" WHERE "+oOrden+" LIKE '"+UPPER(cBusca)+"%' ORDER BY "+oOrden+" LIMIT 100" oDatos:=oServer:Query(cQuery,.T.) Else If nKey=190 cbusca :=cbusca + "." Else cbusca :=cbusca + Upper(chr(nkey)) Endif cQuery:="SELECT ...
by jbrita
Mon Apr 02, 2012 12:15 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Ejemplo xBrowse-MySql?
Replies: 7
Views: 2061

Acceso al ERP Infor (BaaN / LN) mediante OLE Automation

... the following example shows how to quit the BAAN application.      Baan4Obj.Quit     Set Baan4Obj = Nothing 3 Limitations Following are some limitations when using the OLE Automation interface: • Due to the limitation in the 3GL function parse_and_exec_function, it will not be possible to ...
by Baxajaun
Mon Mar 26, 2012 8:45 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Acceso al ERP Infor (BaaN / LN) mediante OLE Automation
Replies: 0
Views: 1272

Re: Objects that disappear within the control Group

... from Code and Resource . A Group-test ( Dialog and TFolderEx ) is included. Still a little bit Finetuning needed. I tested to the Limit , but couldn't detect a Problem. I just noticed a little Problem with BtnBmp Prompt Auto-Linefeed ( not centered ) like You can see in the Main-Screenshot. ...
by ukoenig
Tue Mar 20, 2012 8:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Objects that disappear within the control Group (SOLVED)
Replies: 25
Views: 5762

Re: OT: XBrowse-MySql-TMysql

... := oTempo:lin oServer:Query("UPDATE goptempo SET lin = '"+cValToChar(nLin)+"' WHERE lin = '"+cValToChar(nLinAnter)+"' LIMIT 1") oTempo:Skip() nLin+=1 Enddo oServer:Query("DELETE FROM gopmult") //borramos todos los reg en tabla principal (esta tabla tiene ...
by FranciscoA
Tue Mar 13, 2012 1:22 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: OT: XBrowse-MySql-TMysql
Replies: 28
Views: 8782

Re: Pregunta No 1 Para Amigo Daniel

Daniel. Pregunta No 1 Que diferencia hay entre oQry = oServer:Query( "SELECT * FROM clientes limit 20" ) y oQry = TDolphinQry():New( "SELECT * FROM test", oServer ) ninguna Pregunta No 2 Veo que Locate y Find Funcionan Igual Me corriges si me equivoco.. ...
by Daniel Garcia-Gil
Fri Mar 02, 2012 9:48 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Pregunta No 1 Para Amigo Daniel
Replies: 1
Views: 426

Pregunta No 1 Para Amigo Daniel

Saludos. Daniel. Pregunta No 1 Que diferencia hay entre oQry = oServer:Query( "SELECT * FROM clientes limit 20" ) y oQry = TDolphinQry():New( "SELECT * FROM test", oServer ) Pregunta No 2 Veo que Locate y Find Funcionan Igual Me corriges si me equivoco.. ...
by ruben Dario
Fri Mar 02, 2012 9:27 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Pregunta No 1 Para Amigo Daniel
Replies: 1
Views: 426

several questions about xBrowse

... NIL I have some questions: 1.- Using the scroll, if trying to go down after the last row it executes bPastEof. Is it possible to limit that only to keydown´s key?. 2.- When adding a new line, I want to set the line to edit mode but I also want the button: http://img39.imageshack.us/img39/9222/xbrowse.th.png ...
by ukservice
Fri Dec 16, 2011 10:33 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: several questions about xBrowse
Replies: 12
Views: 3586

Re: xBrowse - Busqueda Incremental

... "+ cSelect + " FROM "+oTabla+" WHERE "+oOrden+" LIKE '"+UPPER(cBusca)+"%' ORDER BY "+oOrden+" LIMIT 100" oDatos:=oServer:Query(cQuery,.T.) Else If nKey=190 cbusca :=cbusca + "." Else cbusca :=cbusca + Upper(chr(nkey)) Endif cQuery:="SELECT ...
by jbrita
Fri Dec 02, 2011 2:30 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: xBrowse - Busqueda Incremental
Replies: 7
Views: 1870

Re: Tdolphin Subselects

... "simples" Dolphin separa individualmente el valos de las sentencias y poder asignarlas de manera individual (WHERE,  GROUP, HAVING, LIMIT, ORDER) Puede dejar que dolphin construya  las sentencias "simples" por ud podrias crear una plantilla de la consulta y cambiar los ...
by Daniel Garcia-Gil
Fri Nov 18, 2011 11:05 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Tdolphin Subselects
Replies: 3
Views: 1236

Re: SqLite in network

Hello Ramesh, Sqlite3 hasn't a user/psw authentication. If you want to limit the access you should crypt the database using: 1 - the SEE encryption module 2 - or the variour crypt add-ons available 3 - or crypting the data from yourself The 1 and 2 methods ...
by Marco Turco
Sat Oct 29, 2011 7:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: SqLite in network
Replies: 24
Views: 7004

Re: MS Access problem

Bayron Thanks for your second suggestion .. setting the handle count had no effect .. It just seems there is a limit on how many times ( usually 10 opens and closes ) Access will allow .. Darnedest thing I have ever seen .. I have built my whole program around Access and in the ...
by Rick Lipkin
Fri Oct 14, 2011 2:35 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: MS Access problem
Replies: 12
Views: 4836

Re: Webcams OF LAITON

I open different cam
OCam1,oCam2,oCam3,oCam4


but not run ok

is a limit of webcam class
perhaps we can create Webcam function and open an different object but we must open different cam ip...perhaps can run it !!
by MdaSolution
Tue Sep 27, 2011 9:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Webcams OF LAITON
Replies: 7
Views: 1542

Re: ¿se puede hacer con xBrowse?

... "+ cSelect + " FROM "+oTabla+" WHERE "+oOrden+" LIKE '"+UPPER(cBusca)+"%' ORDER BY "+oOrden+" LIMIT 100" oDatos:=oServer:Query(cQuery,.T.) Else If nKey=190 cbusca :=cbusca + "." Else cbusca :=cbusca + Upper(chr(nkey)) Endif cQuery:="SELECT ...
by jbrita
Wed Aug 03, 2011 3:56 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ¿se puede hacer con xBrowse?
Replies: 13
Views: 2852

Re: Pregunta Mysql al Abrir la misma tabla desde 2 PC

... := adLockPessimistic oRecordSet[nRecordSet]:Open( "Select "+ cSelect +" from " + cTabla + " ORDER BY "+cOrder+" LIMIT 50" , oConexion,1, 3 ) Else oRecordSet[nRecordSet]:= TOleAuto():New( "ADODB.Recordset" ) oRecordSet[nRecordSet]:CacheSize := 50 ...
by jbrita
Wed Jul 13, 2011 1:33 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Pregunta Mysql al Abrir la misma tabla desde 2 PC
Replies: 7
Views: 1491

Re: How to define xBrowse-textcolor on diff. Backgrounds ?

Mr. Uwe This is the logic adopted inside XBrowse. The luminance of the center line of each cell is calculated and if it exceeds a particular limit, black color is chosen and otherwise white color is chosen. The luminance may vary between adjacent cells even in a single row when image backgrounds ...
by nageswaragunupudi
Wed Jun 22, 2011 3:50 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: How to define xBrowse-textcolor on diff. Backgrounds ?
Replies: 4
Views: 1515
PreviousNext

Return to advanced search