Search found 225 matches: inserting

Return to advanced search

Re: FWHMYSQL/MARIADB: Stored Procedures and Functions

... of fields `StateID`, `StateCode` and `StateName` are in fact `id`, `code`, `name`. That is how the RowSet is able to offer editing, deleting and inserting. Now let us raise a question ourselves and answer it. When it is possible to create a rowset from the Sql statement directly, why should anybody ...
by nageswaragunupudi
Sun Dec 04, 2016 3:11 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWHMYSQL/MARIADB: Stored Procedures and Functions
Replies: 5
Views: 2976

FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )

... be array of field names or comma delimited list of field names Param aValues: Array of values corresponding to the fields. A Single dim array for inserting single row and multi-dim array for inserting multiple rows in one operation. The values can be constants or variables or expressions, Examples: ...
by nageswaragunupudi
Fri Jul 01, 2016 9:32 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Replies: 76
Views: 28960

Re: xBrowse improvement

... cursor can be slow because it provides only single row access — there is no batch cursor available. Server-side cursors are useful when inserting, updating, or deleting records. With server-side cursors, you can have multiple active statements on the same connection.
by Rick Lipkin
Wed Apr 13, 2016 1:06 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse improvement
Replies: 2
Views: 606

Re: xBrowse jpg in SQL-database

We advise 4 simple ways of inserting images into Ado table. Following program works for any database. #include "fivewin.ch"#include "adodef.ch"  // important//----------------------------------------------------------------------------//function ...
by nageswaragunupudi
Sun Dec 27, 2015 10:25 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse jpg in SQL-database
Replies: 19
Views: 3072

Re: New FTDN September/Septiembre 2015 (FWH 15.09)

... item to set the width of menus * Unicode support extended to all controls. Existing applications turn into multi-lingual unicode application by inserting one line of code in the Main function FW_SetUnicode( .t. ) This being a major revision, we request the users to provide feedback to help improvements. ...
by Antonio Linares
Thu Oct 15, 2015 2:57 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN September/Septiembre 2015 (FWH 15.09)
Replies: 52
Views: 15311

New FTDN September/Septiembre 2015 (FWH 15.09)

September 2015 ============== * Unicode support extended to all controls. Existing applications turn into multi-lingual unicode application by inserting one line of code in the Main function FW_SetUnicode( .t. ) This being a major revision, we request the users to provide feedback to help improvements. ...
by Antonio Linares
Sat Sep 26, 2015 8:24 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN September/Septiembre 2015 (FWH 15.09)
Replies: 52
Views: 15311

Re: DBF to SQL converter program

... good referential integrity rule satisfying id, then try having a GUID field. GUIDs are implemented by most SQL engines and are auto generated when inserting a new record. A GUID is guaranteed to be GLOBALLY unique. I use these ID's for things like customer numbers, invoice numbers, etc. so they ...
by James Bott
Tue Aug 25, 2015 6:49 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 18365

Re: DBF to SQL converter program

... good referential integrity rule satisfying id, then try having a GUID field. GUIDs are implemented by most SQL engines and are auto generated when inserting a new record. A GUID is guaranteed to be GLOBALLY unique. (2) implement transactions. Most SQL engines allow you to start-end-roll back a ...
by reinaldocrespo
Tue Aug 25, 2015 5:16 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to SQL converter program
Replies: 59
Views: 18365

Re: Word and OLE

... existing document - between existing lines on the document. I was thinking of adding a single row table into the template - finding the table and inserting the data and adding more rows as needed. Thanks Colin Try this code :) TRY    oWord := CreateObject("Word.Application")CATCH  ...
by anserkk
Tue Jul 14, 2015 4:40 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Word and OLE
Replies: 5
Views: 1041

Re: Word and OLE

... existing document - between existing lines on the document. I was thinking of adding a single row table into the template - finding the table and inserting the data and adding more rows as needed. Thanks Colin
by Colin Haig
Mon Jul 13, 2015 11:32 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Word and OLE
Replies: 5
Views: 1041

Re: 2155 error hb_cdxindexCheckVersion fivewin/harbour

Please, no one has encountered this error?

I think it is a general index error depending on system suspension.

I have also read ( do not remeber where) that someone had adopted a trick
inserting at program initialization a "Request"

REQUEST DESCEND

but not working for me.
by lorenzoazz
Mon Jun 29, 2015 6:41 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: 2155 error hb_cdxindexCheckVersion fivewin/harbour
Replies: 16
Views: 3613

Re: ADO and empty Dates

... cSql )  Even better cSql := SQL UPDATE MYTABLE SET DOCDT = dDate WHERE ID - 0 For ado, you may use FW_AdoNull() for updating or inserting empty dates
by nageswaragunupudi
Sat May 23, 2015 10:24 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO and empty Dates [SOLVED]
Replies: 2
Views: 378

Re: FYI Tablet App

... from the FiveWin samples. I started using this functions some days ago but my signature does not paint as nice as yours. I am testing now with inserting some sysrefresh(). And I planed to use a timer to get more painting coordinates. I am curious if you have a dll or if you use CaptureSignature() ...
by Otto
Wed May 13, 2015 8:00 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FYI Tablet App
Replies: 14
Views: 5045

Re: FYI Tablet App

... from the FiveWin samples. I started using this functions some days ago but my signature does not paint as nice as yours. I am testing now with inserting some sysrefresh(). And I planed to use a timer to get more painting coordinates. I am curious if you have a dll or if you use CaptureSignature() ...
by Otto
Wed May 13, 2015 8:00 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FYI Tablet App
Replies: 14
Views: 5045

Re: Imagenes en Postgress

postgre: Did you use BITEA field type for binary data? First please try inserting small data. It appears postgre ver 9.0 and later accept Hex format like this: E'x\\<hex> or in all versions E'\\octal\\octal, etc Let us first start with some test data and ...
by nageswaragunupudi
Mon Apr 20, 2015 2:42 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Imagenes en Postgress - SOLUCIONADO
Replies: 24
Views: 6113
PreviousNext

Return to advanced search