Search found 1033 matches: append

Return to advanced search

Re: Execute php or vbs code

Here it is: https://wormhole.app/6lE98#DrUiOoCwc3x7kgJ2O-EDDA Enrico, using Antonio's example, I have several errors. Need some other lib? Error: Unresolved external 'WSAIoctl' referenced from D:\LANG\FWH1105\XH1.2.1\LIB\HBCURL.LIB|hbcurl Error: Unresolved external '_curl_global_init_mem' r...
by wartiaga
Sat Sep 02, 2023 3:10 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Execute php or vbs code
Replies: 18
Views: 1242

PostgreSQL and Fivewin

... was add FIELD "ID" is used as PRIMARY KEY and work "autoincrement" but METHOD SavePQQ() use currval() AFTER (!) INSERT when APPEND so Fivewin Sample c:\fwh\samples\testpgre.prg FAIL when try to APPEND new Data https://i.postimg.cc/m2DKsW4m/add-Cusomer-fail.jpg ...
by Jimmy
Fri Aug 25, 2023 4:10 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: PostgreSQL and Fivewin
Replies: 1
Views: 159

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

... for cDbms = "MS JET EXCEL 12.0" and ACE Version --- is it possible to "integrate" a Progressbar in MsgRun() when append Data :?:
by Jimmy
Wed Aug 16, 2023 1:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2974

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

... adBoolean, ;           IF( aFld[ 2 ] $ "+N", adDouble, adLongVarWChar ) ) ) )   oTable:Columns:Append( aFld[ 1 ], nType )   IF i == 7      oCat:Tables:Append( oTable )      oTable := oCat:Tables( cTable )   ENDIF  ...
by Jimmy
Wed Aug 16, 2023 5:22 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: DBF to Excel Sheet, without Excel, using ADO ?
Replies: 50
Views: 2974

Excel empty( dDATE ) fail when Import

hi,

a DBF can have a EMPTY() FIELD Type "D" but when import it to Excel it fail
what is the Way to create a Excel Sheet where i can APPEND empty DATE ?
by Jimmy
Fri Aug 11, 2023 7:42 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Excel empty( dDATE ) fail when Import
Replies: 0
Views: 161

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

nageswaragunupudi wrote:
using c:\fwh\samples\testpgre.prg i can open Table "CUSTOMER"
it work fine when "edit" but when try to APPEND it does crash
Image
it have to do with

We will get back soon with a solution


Fixed.
Please wait a little and we will send you the modified "pgsuport.prg"
by nageswaragunupudi
Sat Aug 05, 2023 11:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 858

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

using c:\fwh\samples\testpgre.prg i can open Table "CUSTOMER"
it work fine when "edit" but when try to APPEND it does crash
Image
it have to do with

We will get back soon with a solution
by nageswaragunupudi
Sat Aug 05, 2023 10:27 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 858

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

in multi-User Environment 2 User can APPEND "same" at "same Time" so i can´t use Information like "First+Last" as "Key" you need a PRIMARY KEY Type SERIAL where nextVal() ( NOT currval() ) is used when ...
by nageswaragunupudi
Sat Aug 05, 2023 9:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 858

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

hi, using c:\fwh\samples\testpgre.prg i can open Table "CUSTOMER" it work fine when "edit" but when try to APPEND it does crash https://i.postimg.cc/VNSmq4WF/no-currval-def.jpg it have to do with 9.15. Sequence Manipulation Functions Sequence Functions ...
by Jimmy
Sat Aug 05, 2023 9:31 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 858

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

... it is a single ROW to "save" how did a Sample using AND look like :?: --- now it work with ANSI ans UTF8 Table :) p.s. have not try APPEND yet   IF lAppend .AND. !EMPTY( cSeq )      nCurVal := FWPG_Execute( oQry, "SELECT currval( '" + cSeq + "' )" ...
by Jimmy
Thu Aug 03, 2023 9:13 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 858

Re: "id" for PRIMARY KEY ?

... your primary key .. there is nothing to stop a malicious attack to insert new rows into your SQL table. If I, on the other hand, have a routine on append to create programmatically to create a unique ID .. I don't have to worry about a hacker getting into my sql machine and trying to inject bogus ...
by Rick Lipkin
Tue Jul 25, 2023 6:46 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "id" for PRIMARY KEY ?
Replies: 9
Views: 525

Re: "id" for PRIMARY KEY ?

Jimmy I create my own primary keys that way I control when a table is appended .. if you use auto increment an attacker could force an table append or "Inject" records into your tables and the database doesn't care .. the primary keys are generated ...
by nageswaragunupudi
Tue Jul 25, 2023 2:10 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "id" for PRIMARY KEY ?
Replies: 9
Views: 525

Re: "id" for PRIMARY KEY ?

Jimmy I create my own primary keys that way I control when a table is appended .. if you use auto increment an attacker could force an table append or "Inject" records into your tables and the database doesn't care .. the primary keys are generated ...
by Rick Lipkin
Tue Jul 25, 2023 1:48 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "id" for PRIMARY KEY ?
Replies: 9
Views: 525

Peticion POST a xHarbour

... String line; StringBuffer responsee = new StringBuffer(); while((line = rd.readLine()) != null) { responsee.append(line); responsee.append('\r'); } rd.close(); String respuesta = responsee.toString(); //----------------------------------------------------------------- ...
by servicomver
Mon Jun 05, 2023 11:15 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Peticion POST a xHarbour
Replies: 3
Views: 443

Re: new Array for XBROWSE -> only 1st Column ?

... and "wide" is FCOUNT(). but with my CODE it show only 1st Column "A" when assign "on-fly" to XBROWSE --- instead of APPEND to DBF i want to "show" Data using XBROWSE                SELECT 1               aValues := Scatter() // FieldGet()        ...
by Jimmy
Thu May 25, 2023 7:25 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: new Array for XBROWSE -> only 1st Column ?
Replies: 7
Views: 337
PreviousNext

Return to advanced search