Search found 27 matches: constraints

Searched query: constraints

by Maurizio
Thu Jul 18, 2024 6:55 am
Forum: FiveWin for Harbour/xHarbour
Topic: Dbf/cdx to sql changing
Replies: 53
Views: 9371

Re: Dbf/cdx to sql changing

... Load Balancing: SQL databases can be distributed across multiple 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 ...
by Otto
Fri Feb 09, 2024 8:12 pm
Forum: FiveWin for Harbour/xHarbour
Topic: IS IT POSSIBLE TO MAKE THIS CONTROL
Replies: 16
Views: 2937

Re: IS IT POSSIBLE TO MAKE THIS CONTROL

Tim,
The challenge of integrating modern UI elements into traditional applications involves technological compromises and economic constraints.

The cost of updates, for example for TSwitch, can outweigh the benefits, leading to a difficult balance between innovation and financial feasibility.

I'm ...
by nageswaragunupudi
Thu Aug 03, 2023 4:57 pm
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 3154

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

... have different ideas and preferences.

I personally know such cases of very complex primary keys. Just those programmers' choice.
eg: constraints like
PRIMARY KEY (BRANCH,DEPT,ROWID) where branch and dept are character fields and rowid is an integer.
The programmer feels it is convenient ...
by Antonio Linares
Sun Apr 09, 2023 11:51 am
Forum: latest AI news
Topic: Understanding how autoGPT works...
Replies: 6
Views: 4055

Understanding how autoGPT works...

... strengths as an LLM and pursue simple strategies with no legal complications.

GOALS:

1. calculate current planets positions in zodiac houses


CONSTRAINTS:

1. ~4000 word limit for short term memory. Your short term memory is short, so immediately save important information to files.
2. If you are ...
by goosfancito
Tue Sep 28, 2021 8:18 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Replies: 76
Views: 37979

Re: FWH : Built-in MySql/MariaDB functionality

... CURRENT_TIMESTAMP, `changedt` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)

Example showing how to specify foreign key constraints, collations, calculated columns ( mysql 5.7 and above):
aStru := { ; { "code", "REFERENCES states( code )" }, ; { "details ...
by Silvio.Falconi
Wed Apr 10, 2019 5:08 pm
Forum: FiveWin for Harbour/xHarbour
Topic: SayBarCode control
Replies: 34
Views: 10002

Re: SayBarCode control

... with the vertical lines printed, the code is not read:

https://i.postimg.cc/N0cwJMZR/bcg-linearxwrong.gif

This involves some constraints on the positioning of the code itself, since the reading device must be on the bar code passing directive and with the reading line ...
by nageswaragunupudi
Wed Sep 12, 2018 3:10 am
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDB RS AppendBlank (SOLVED)
Replies: 12
Views: 2317

Re: MariaDB RS AppendBlank

... Other', 'NotSpecified' )

Enum values are automatically shown with EditListBox in XBrowse and default edit dialogs.
User foreign key constraints and computed columns wherever appropriate.

Forcing upper/lower case:

Use COMMENT 'CASE:UPPER'
or COMMENT 'CASE:lower'
or COMMENT 'CASE:Proper ...
by nageswaragunupudi
Sat Feb 17, 2018 10:59 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Copying and Pasting Records
Replies: 3
Views: 1001

Copying and Pasting Records

... of the programmer to ensure that the source and destination fields have the same data type and widths and also values pasted respect the data constraints of the destination table (eg: Unique values should not be repeated). For this purpose, the programmer can change the values of some fields or ...
by Antonio Linares
Mon May 15, 2017 8:53 am
Forum: FiveWin para Harbour/xHarbour
Topic: Conferencia internacional de Harbour+FWH - Sesiones
Replies: 0
Views: 1338

Conferencia internacional de Harbour+FWH - Sesiones

... Database


* ISAM vs. SQL and how you can still do both with ADS
* ADT, VFP, Extended field types
* Data Dictionaries
* Field defaults and constraints
* SQL scripting language and some query tools
* Triggers
* Stored procedures and User defined functions
* Referential integrity (RI ...
by nageswaragunupudi
Sun May 14, 2017 1:19 am
Forum: FiveWin for Harbour/xHarbour
Topic: 1st FWH + [x]Harbour 2017 international conference
Replies: 68
Views: 305805

Re: 1st FWH + [x]Harbour 2017 international conference

... Database


* ISAM vs. SQL and how you can still do both with ADS
* ADT, VFP, Extended field types
* Data Dictionaries
* Field defaults and constraints
* SQL scripting language and some query tools
* Triggers
* Stored procedures and User defined functions
* Referential integrity (RI ...
by nageswaragunupudi
Wed May 10, 2017 7:59 am
Forum: FiveWin for Harbour/xHarbour
Topic: FWHMARIADB Samples
Replies: 48
Views: 25940

Re: FWHMARIADB Samples

... You can see the syntax how to use CHECK constraint and also how it works during execution, if you install this version of the server.

Check constraints can be for a column or for a table. In this sample, we demonstrated only column level constraints but not table level constraints. Table level ...
by nageswaragunupudi
Wed May 03, 2017 2:29 pm
Forum: FiveWin for Harbour/xHarbour
Topic: FWHMARIADB Samples
Replies: 48
Views: 25940

Re: FWHMARIADB Samples

... Points of interest:
1) Implementation of Transactions.
2) Database integrity at server level through
a) Foreign key relationships
b) Unique constraints
c) column validations
d) calculation of dependent columns
e) updation of related tables
f) ENUM type of column
3) Triggers and stored ...
by reinaldocrespo
Sun Mar 26, 2017 4:04 pm
Forum: FiveWin for Harbour/xHarbour
Topic: 1st FWH + [x]Harbour 2017 international conference
Replies: 68
Views: 305805

Re: 1st FWH + [x]Harbour 2017 international conference

... Local-Remote-AIS servers
Advantage Tools
ADT vs DBF
Full Text Search
Understanding Data Dictionaries
Encryption and security
Defining data constraints and referencial integrity
Transactions
SQL
Triggers
Stored Procedures
Notifications
Backup and Restore
Replication

I understand we ...
by nageswaragunupudi
Fri Sep 23, 2016 1:02 am
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 16.08 : Built-in MySql/MariaDB functionality (Updated )
Replies: 76
Views: 37979

Re: FWH : Built-in MySql/MariaDB functionality

... nbsp;  `changedt` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)

Example showing how to specify foreign key constraints, collations, calculated columns ( mysql 5.7 and above):
  aStru := {  ;              &nbsp ...
by nageswaragunupudi
Fri Mar 20, 2015 2:50 pm
Forum: FiveWin for Harbour/xHarbour
Topic: TTaskPanel
Replies: 6
Views: 1798

Re: TTaskPanel

Is it so wrong to want a transparent TExplorerBar?
Not at all.
I see that this modification is not present in FWH 15.03, why?
Due to constraints of time, we may not be able to accommodate every proposal "immediately". Urgent changes and fixes get priority.
Meanwhile, would you be pleased to ...