FiveTech Software tech support forums

... number, accounting, etc ). Since I have classes for each process like work orders, my Add() method appends a record, fills the buffers with blanks, then goes to the counter dbf, increments the proper number, saves the value back to the record, and saves it to the appended record. The interaction ...

... number, accounting, etc ). Since I have classes for each process like work orders, my Add() method appends a record, fills the buffers with blanks, then goes to the counter dbf, increments the proper number, saves the value back to the record, and saves it to the appended record. The interaction ...

... "WINDOWS"C=10WRITE MYREK or some fields: A = "ADO"B= "AS400"WRITE MYREK in seconds case field C has blanks (manages inside DB) in AS400 I use SQL istruction: SELECT * FROM MYTABLE I get: n.Rek     A                       B                    C00001 ...

... Per eseguire l'operazione richiesta è necessario disporre di un record corrente.: VALUE I know that inside field 95 there is a bad value (blanks instead zeros) and then: oRs:Fields( 95 ):Name = ERROR like oRs:RecordCount()

hi mr Rao,
I'm checking myTable, and now I understand that there are a lot of fields that have blanks value in numeric field.
I'd like that FW_OpenRecordSet manages this situation.

... field till all fields or values are written. If a fieldlist is provided, the values are written to the fields in that order. The list can contain blanks or invalid field names and such fields are skipped. New parameters 4,5 and 6. 4. lOverWrite (optional default .f.) - If set to .t., records from ...

Thats correct
There are some invalid state codes and some blanks in the table.
This is a public database and anyone can enter data and there are many incomplete records.
Whatever the info is there, it is shown correctly

... = {|| _AddNewRow( oRsDetail,nRepairNumber,nAssignedTo,cLoc,oLbxB,"Y",oRsRepair,"" ) }  Then I fill in the blanks and add my primary key .. just kinda follow the flow .. not the logic.. Rick Lipkin //----------------Static Func _AddNewRow( oRsDetail,nRN,nTech,cLocation,oBrw,cAsk,oRsRepair,cReturn ...

... tried a long file name - I was never able to compile long file names with build.bat now with your editor it worked Ok. Name of file with spaces blanks also run super Please, if you have doubts, send me a mail and connect for TeamViewer As many times as you need thank you so much. how can I start ...

... the problem is specific to Harbour / MSVC, and clearly relates to fonts ( which you redefine In the xBrowse changes for 16.12 ) because it also blanks out the fonts on the prompts for the button bar. Tim

1) To show blanks instead of Zeros Recommended way is to set oBrw:lDisplayZeros := .t. ( To the extent possible, we may not directly use bStrData) 2) Master Child Browses: I assume you are using DBFCDX. The preferred way is to ...

... Pads numbers with zeros instead of blank spaces R Nontemplate characters are inserted X Adds DB (debit) after negative numbers Z Formats zeros as blanks ( Encloses negative numbers in parentheses ! Converts alphabetic characters to uppercase

... and size of bitmap ) one row is not enough. Therefore the prompt is painted in two lines vertically centered. We do not notice because they are blanks. If you do not use padding, you will notice t hat the prompts are appropriately aligned and I hope they should also look aesthetically well But ...

... , "CUSTOMER", oCon ) if oRs:use() // proceed else // error opening endif Other methods are similar to TDatabase // Fields containing blanks can be accessed/assigned by replacing spaces with '_'. Examples: Where field name is "Join Date" oRs:Join_Date := Date() oRs:FieldGet( ...

... also use familiar fieldget, etc. oRs:FieldGet( "Salary" ) oRs:FieldPut( "Salary", 40000 ) While using field names containing blanks, we can replace blanks with underscore. Example: Where a field name is "Sale Price", ? oRs:Sale_Price ? oRs:FieldGet( "Sale_Price" ...