Search results for query: *

Hello You select driver "MSSQL" for each table in the dictionary. There is help example with SQLite.

How about comparing destination file size with oryginal ?

Maybe the same way you did it but for me it looks fast enough because it skips lines already processed. ( force QUICKSCAN driver option, default is off when not read only for others ) 1. Start from begining of the file and copy to queue intil EOF, save filepointer, reverse queue, process 2...

Maybe, if file is not that big, copy it into queue(n,line) and sort reverse or sort file with external program.

Has anyone upgraded to V7 using legacy templates ? We did upgrade of the big project. Was it easy ? Not. 1000+ errors. Mostly Windows and Reports templates. Every one had to be manualy corrected. Legacy Embeds worked without problems. Was it worth doing ? No but we had to. We upgraded office PCs...

TopScan database viewer can do it by default. -> File -> Export...

Not much help but in situation like this I enable query login in PostgreSql. Queries generated by Clarion ODBC can be scary.

hmm... I never use SET() with {Prop:sql}. Examples in help manual don't use it either.

So instert works. 1. Do you use NEXT(TEMP_INTEGER) after select ? ;) 2. Does first field of TEMP_INTEGER match rb type ? 3. Try objekti_foto{PROP:SQL} = 'select * from objekti_foto where id_objekta = ' & clip(BRW1.q.OBJEKTI:ID) and check if it works.

Maybe conversion changed dictionary table to not SQL driver ? What is errcorode number and FILEERROR() ?

Button trick works, thx.

Hi It doesn't work. Form opens for ChangeRecord. Right now I set special flag on MouseLeft2 and change variable called Request right before form procedure starts. It's ugly because there is no special embed for that and I have to edit source code. ThisWindow.Run PROCEDURE(USHORT Number,BYTE...

I don't have access to code today. I think It was wery raw. BCode STRING(15) ClearBCode BYTE Armed EQUATE(2) ---> WindowEvents AlertKey IF len(clip(Bcode)) > 0 AND NOT ClearBCode ClearBCode = TRUE END ---> WindowEvents Timer (200ms) IF ClearBCode IF ClearBCode = Armed...

Hello I use time limit to finish barcode scan. There is no way user can type 11 numbers in 200ms.

Hello I'm trying to find nice solution to change double click on browse LIST from ChangeRecord to ViewRecord. No succes so far. Please post you ideas.( Clarion 7 ABC )

Hi I think there is no problem if queue type is declared in globals or is system type queue. However I can't racall real example passing custom queues I have nice usage of system print queue . My Example: ChangeTotalPagesCounter PROCEDURE (PrintPreviewFileQueue pqPages)

Is it correct to use qTest2 :=: qTest1 instead of qTest2.Data = qTest1.Data qTest2.Data2 = qTest1.Data2 qTest2.Data3 = qTest1.Data3 ... in the loop ?

Thank You

Hi I have project in multiple dlls that share the same equates. Is there a way to create one file with equates only and use it in every dll. I use C7.

We use transactions when possible but in this situation it doesn't work. User's edit form can lock related table for long time. We have other automated processes writing into that tables that won't stop and wait for COMMIT OR ROLLBACK ( scanners reading barcodes) We tried different isolation...