Search found 535 matches: whatever

Return to advanced search

Re: Cuantas columnas tiene una tabla?

Hello, with the native Fivewin I think it is: oRs:Fields:Count With ADO, oRs:Fields:Count(), whatever be the database. With FWH native MySql/Mara library, both work oRs:Fields:Count() or oRs:FCount(). The native library supports both complete ADO syntax as well as normal ...
by nageswaragunupudi
Sat Sep 02, 2023 3:01 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Cuantas columnas tiene una tabla? (SOLUCIONADO)
Replies: 6
Views: 453

Re: DBF to Excel Sheet, without Excel, using ADO ?

... oTable )            oTable := oCat:Tables( cTable )         endif      return nil      > )return nil  Kindly note that whatever code I post in the forums, is only after fully testing at my end. It has to work 100% if used exactly as I posted.
by nageswaragunupudi
Wed Aug 16, 2023 8:46 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2586

Re: DBF to Excel Sheet, without Excel, using ADO ?

Whatever DefinedSize we specify while creating the table (via sql or adox), when the table is read using ADO, the field object is showing oField:DefinedSize as 255 only
by nageswaragunupudi
Wed Aug 16, 2023 11:24 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2586

Re: DBF to Excel Sheet, without Excel, using ADO ?

... points: 1. I prefer adopting the sql approach than using ADOX. 2. We need to be aware of the limitations of creating Excel sheets using ADO. a) Whatever length we specify, all character columns are VarChar(255) b) Whatever numeric datatype, like int, numeric(w,d), etc we specify the columns ...
by nageswaragunupudi
Mon Aug 14, 2023 10:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2586

Re: ADO / Excel / XBROWSE / FWAdoStruct() / Edit()

FWAdoStruct() gets the information from each field object of the RecordSet. The issue with ADO for Excel is, whatever length of char we specify it always returns 255. oField:DefinedSize. Please try this:   n := 0   aFields := {}   do while n ...
by nageswaragunupudi
Mon Aug 14, 2023 4:44 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO / Excel / XBROWSE / FWAdoStruct() / Edit()
Replies: 8
Views: 261

Re: ADO / Excel / XBROWSE / FWAdoStruct() / Edit()

That is the issue with ADO with Excel.
Whatever length you specify while creating the table, that is ignored.
ADO RecordSet field object always shows oField:DefinedSize as 255.
by nageswaragunupudi
Sun Aug 13, 2023 10:32 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO / Excel / XBROWSE / FWAdoStruct() / Edit()
Replies: 8
Views: 261

Re: "id" for PRIMARY KEY ?

Rao .. I do not have an answer .. My "primary key procedure" is more of a preventative measure to keep attackers (from using whatever means) to hack my tables and covertly insert rows .

Rick Lipkin
by Rick Lipkin
Thu Jul 27, 2023 1:11 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "id" for PRIMARY KEY ?
Replies: 9
Views: 479

Re: show DELETED Record in XBROWSE

Whatever happens to your end, you should be able to reproduce with a sample.
Like whatever we said, we proved with a sample.
by nageswaragunupudi
Sat May 27, 2023 9:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: show DELETED Record in XBROWSE
Replies: 11
Views: 475

Re: show DELETED Record in XBROWSE

Whatever happens to your end, you should be able to reproduce with a sample.
Like whatever we said, we proved with a sample.
by nageswaragunupudi
Sat May 27, 2023 9:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: show DELETED Record in XBROWSE
Replies: 11
Views: 475

Re: Can I get object from handle?

... Then have your apps listen for that message on another thread. If the message is received, then update the object being displayed or execute whatever code to handle the message. I know this is not exactly what you are asking but it might be a possible solution. I do this a lot using triggers ...
by reinaldocrespo
Sun Apr 16, 2023 5:25 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Can I get object from handle?
Replies: 15
Views: 1348

xBrowse: Auto save edit

... typing into a cell in xBrowse (FASTEDIT clause used), without pressing Enter I immediately click the Print button. I find that if I do that whatever I recently keyed-in is not saved. It will only be saved if I pressed Enter before clicking the the Print button. Is there some setting/flag ...
by hua
Tue Mar 07, 2023 10:41 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse: Auto save edit
Replies: 2
Views: 361

Re: What is the best PDF Printer Driver Windows to use with Five

You Can use FWharu .... Rao can give you help .. generate your .pdf within your code and save it out to the operating system and then attach it via whatever e-mail transport of your choice.

Rick Lipkin
by Rick Lipkin
Sat Jan 28, 2023 3:03 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: What is the best PDF Printer Driver Windows to use with Five
Replies: 11
Views: 805

Re: What is the best PDF Printer Driver Windows to use with Five

... the time ENDPRINT command finishes the job, "yourname.pdf" is created silently and is ready on the disk for you to send by email or do whatever. Please do not get distracted by any other advices.
by nageswaragunupudi
Sat Jan 28, 2023 12:35 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: What is the best PDF Printer Driver Windows to use with Five
Replies: 11
Views: 805

Re: Is Xbrowse Barget still intended to filter data

BarGet's purpose is not just for filtering. This helps us to GET some value and it is for us to do whatever with that Value, whether we use for filter or for seek or for setting scopes or for whatever purpose. Do not underestimate filters. Scope has limited scope. What I ...
by Marc Venken
Sat Nov 05, 2022 4:06 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Is Xbrowse Barget still intended to filter data
Replies: 2
Views: 212

Re: Is Xbrowse Barget still intended to filter data

BarGet's purpose is not just for filtering. This helps us to GET some value and it is for us to do whatever with that Value, whether we use for filter or for seek or for setting scopes or for whatever purpose. Do not underestimate filters. Scope has limited scope. What I ...
by nageswaragunupudi
Sat Nov 05, 2022 3:17 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Is Xbrowse Barget still intended to filter data
Replies: 2
Views: 212
PreviousNext

Return to advanced search