FiveTech Software tech support forums

... IF NOT EXISTS armando ";
+"( `id` INT(10) NOT NULL AUTO_INCREMENT, ";
+"`nombre` VARCHAR(50) NOT NULL,";
+"`orden` INT(10) NOT NULL,";
+"PRIMARY KEY (`id`)) ENGINE=INNODB DEFAULT CHARSET=utf8")
//Inserto lo basico
oCn:Execute("INSERT INTO armando (orden,nombre) VALUES (1,'Manzana'),(2 ...

... 30 ),
state VARCHAR( 2 ),
zip VARCHAR( 10 ),
hiredate DATE,
married BOOLEAN,
age INTEGER,
salary DECIMAL( 9, 2 ),
notes VARCHAR( 70 ),
PRIMARY KEY ( id )
)

ENDTEXT

cls

msg( "Traspaso de datos..." )

try
oDb := THDbc():new( _DRIVER_ )

oDb:connect( _CONN_STRING_ )
oDb:exec ...

... nClrBorder`**
- **Type:** NUMERIC
- **Description:** The border color.

22. **`nClrSepara1`**
- **Type:** NUMERIC
- **Description:** The primary separator color.

23. **`nClrSepara2`**
- **Type:** NUMERIC
- **Description:** The secondary separator color.

24. **`nClrTextHeader ...

... Type**: Constructor
- **Parameters**:
- `nWidth`: The width of the bitmap.
- `nHeight`: The height of the bitmap.
- `nColor`: The primary color of the bitmap.
- `nColor2`: (Optional) The secondary color for creating a gradient effect. If not provided, the bitmap will be a flat color ...

... DATA Members**

1. **`hBrush`**
- **Type**: Handle (Numeric)
- **Description**: The handle to the brush object. This is the primary identifier for the brush in the Windows GDI (Graphics Device Interface).

2. **`hBitmap`**
- **Type**: Handle (Numeric)
- **Description**: The ...

ALL OF THIS POST TOGETHER

Remembering that I use GTWVG as primary library.
This is ONE OF my browse calls, change one column for FIVEWIN:

METHOD GridSelection( nType ) CLASS JPCADASTROClass

LOCAL oTBrowse, cnSQL := ADOLocal()

hb_Default( @nType, 0 )

WITH OBJECT cnSQL
:cSQL := "SELECT ...

... DESCRIP` varchar(50) DEFAULT NULL,
`VAL_UNI` float(9,2) DEFAULT NULL,
`VAL_TOT` float(9,2) DEFAULT NULL,
`DIVISA` varchar(3) DEFAULT NULL,
`FECHA` date DEFAULT NULL,
`CATEGORIA` int(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=62706502 DEFAULT CHARSET=latin1;
*/

... standard installation on a powerful machine like an i7 with 16 GB RAM and an SSD, you already have a solid foundation for an RDS environment. For primary use of an article inventory program, where data traffic is key, you might consider the following optimizations:

1. Network Optimization
QoS ...

... visible and independent of the object.
Extensibility: With cargo and data-*, you can store additional metadata that is not necessary for the primary purpose of the element but useful for business logic.
Usage in scripts: This data can be accessed and used in JavaScript (for data-*) and in ...

... overhead was significant when data had to travel between machines.
- Centralized control over data integrity, transactions, and consistency was a primary concern in multi-user environments.

Many people in this forum still do this, and that’s simply a design flaw—there are so many better solutions ...

Answering myself :)

I already found out it. Just add "PRI" in the struct.

Eg: aFld := {{"COD","C",3,0,"PRI"},{"NOME","C",30,0}}

oCn:CreateTable("test", aFld), will create the table " test " and set the field " COD " as your primary key.

... servers, improving scalability and availability.
3. Data Integrity
Integrity Constraints: SQL databases support integrity constraints such as primary keys, foreign keys, and unique constraints, ensuring data integrity.
ACID Transactions: SQL databases support transactions that adhere to ACID ...

... to retain the existing syntax and plan for a gradual migration.

However, if flexibility, performance, and long-term maintainability are the primary concerns, switching to pure HTML and modern web technologies would be the better choice.
A hybrid approach could be a sensible compromise ...

... id is autoincrement field

This should work:
oCn:Upsert( "states", nil, { { 0, "KK", "KState" } } )
For Upsert() to work, we need to include primary key also.
My table have 20 fields, but in this part of process I need edit or insert just a few.

But you can use normal Insert like this:
oCn ...

... has 3 fields: id, code, name where id is autoincrement field

This should work:
oCn:Upsert( "states", nil, { { 0, "KK", "KState" } } )
For Upsert() to work, we need to include primary key also.

But you can use normal Insert like this:
oCn:Insert( "states", "code,name", { { "KK", "KKKK" } } )