topic-39810

Posts: 297

Joined: Fri Apr 14, 2006 05:52 PM

FW MariaDB/MySql native
Posted: Wed Dec 30, 2020 09:36 AM

Hi to all Forum:

First of all I congratulate you on the holidays and wish you a good exit to the year of 2020 (screwed) and a better entry into 2021.

I would need help for the following: I have started to make examples of a CRUD of a table with the native functions of FWH (Ver. 16.10), and the code is similar to what I show:

1) I open the recordset and add a blank record

Code (fw): Select all Collapse

oRs:=oConnection:Rowset("select * from operators")
....
oRs:Add()

2) I manipulate the fields

Code (fw): Select all Collapse

oRs:Codigo:=  ¿¿¿¿¿
oRs:Nombre:=  ?????

3) Finally, I save the record.

Code (fw): Select all Collapse

oRs:Save()

If the server does not give any errors, it works perfectly. The problem is that the table I am manipulating has a UNIQUE index in the "Codigo" field, so if I try to create a record with an existing code, it gives me an error, but the problem is that it is as if the pointer moved and gets lose their values (they go blank). Do you know or do you have any example to be able to carry out this basic process?

Best regards, and thank you very much.

Mike Serra

Posts: 297

Joined: Fri Apr 14, 2006 05:52 PM

Re: FW MariaDB/MySql native
Posted: Sat Jan 02, 2021 06:49 AM

:roll:

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: FW MariaDB/MySql native
Posted: Sat Jan 02, 2021 09:37 AM

Please wait.

Regards

G. N. Rao.

Hyderabad, India

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: FW MariaDB/MySql native
Posted: Sat Jan 02, 2021 11:56 AM

maybe it's the same problem ?

viewtopic.php?f=3t=34272p=203181hilit=Mysql#p203181

Maurizio

&&&

Maurizio
www.nipeservice.com

Mike Serra

Posts: 297

Joined: Fri Apr 14, 2006 05:52 PM

Re: FW MariaDB/MySql native
Posted: Mon Jan 11, 2021 08:32 AM

Good morning.

Any news?

Thanks in advance

Mike Serra

Posts: 297

Joined: Fri Apr 14, 2006 05:52 PM

Re: FW MariaDB/MySql native
Posted: Fri Jan 22, 2021 03:27 PM

Good afternoon.

any news?

Thanks in advance

James Bott

Posts: 4840

Joined: Fri Nov 18, 2005 04:52 PM

Re: FW MariaDB/MySql native
Posted: Fri Jan 22, 2021 05:29 PM

Most databases automatically create the primary key when a new record is added. Thus they won't allow you to update the primary key.

DBFs are the exception to this, however there is now the option to specify an automatic primary key for DBFs too.

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10

Mike Serra

Posts: 297

Joined: Fri Apr 14, 2006 05:52 PM

Re: FW MariaDB/MySql native
Posted: Mon Jan 25, 2021 08:56 AM

Hello James:

Thanks for your comment. Actually, the problem I have is when trying to add a record and the server returns an error (in my case, because the code already exists). In this case, the values of the oRs variable are lost. The code field has created a unique index on the server.

I could carry out this check, but I prefer to control it more securely at the database level, because the application can be accessed from desktop software and web applications.

Thanks.

James Bott

Posts: 4840

Joined: Fri Nov 18, 2005 04:52 PM

Re: FW MariaDB/MySql native
Posted: Mon Jan 25, 2021 02:33 PM

Mike,

I guess I wasn't clear, all you have to do is use automatic primary keys with DBFs. You do this by using the field type "+" for the primary key field. Then when you add a blank record it will automatically get a primary key ID. This way you can use the same code for both DBFs and SQL databases.

Or, maybe still I don't understand your problem?

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10

FiveTech Support Forums

Continue the discussion