Radicore Forum: Framework » Importing default values -> enclosed in quotes

Home » RADICORE development » Framework » Importing default values -> enclosed in quotes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing default values -> enclosed in quotes [message #7872]

Fri, 27 September 2024 05:28

htManager
Messages: 431
Registered: May 2014

Senior Member

When I import columns in the dictionary, the default values ar enclosed in quotes. Is this a problem with my settings?

For example: field foo_bar, varchar( Cool

default value 00:00:00 will be shown in the dictionary as '00:00:00'. This leads to an error in the application because the field length is 10 and this is not entered.

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7873 is a reply to message #7872]

Sat, 28 September 2024 07:57

AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK

Senior Member

Can you give me a copy of your CREATE_TABLE script? I have looked at several examples of columns with default values in my code, such as the created_date and created_user columns on virtuslly every table, and I can see nothing wrong. None of the default values shown in the 2updtae Column" screen are enclosed in quotes.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7874 is a reply to message #7873]

Wed, 02 October 2024 11:42

htManager
Messages: 431
Registered: May 2014

Senior Member

I have inserted the create_table script of my local environment and of my server environment (1) in the zip file. Additionally I inserted a screen shot of the radicore column(list2).php site. The created date value is in quotes, too.

Attachment: radicore column import.zip
(Size: 78.82KB, Downloaded 27 times)

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7875 is a reply to message #7874]

Fri, 04 October 2024 06:10

AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK

Senior Member

I have imported that table definition into my test database and I do not see the problem you have reported. However, I have recently made some changes to my code to remove some deprecation notices that appeared with PHP version 8.3 which I have included in the attached zip file. Can you try these out to see it they solve the issue?

Attachment: RADICORE-patch-2024-10-04.zip
(Size: 277.11KB, Downloaded 22 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Importing default values -> enclosed in quotes [message #7876 is a reply to message #7875]

Fri, 04 October 2024 07:38

htManager
Messages: 431
Registered: May 2014

Senior Member

Unfortunately the same result. In my local environment I have php 8.2.0 installed and in my server environment 8.2.24.

I also have problems with concat_ws with the following code:

$outer_sql_select .= ", CONCAT_WS(' ', CONCAT_WS(' ', spiele_ma_heim_name, spiele_ma_heim_id), ' - ', CONCAT_WS(' ', spiele_ma_fremd_name, spiele_ma_fremd_id)) AS spiele_gegner";

I got an error message, which I attached.

Attachment: radicore concat_ws.jpg
(Size: 639.13KB, Downloaded 63 times)

[Updated on: Fri, 04 October 2024 10:03]

Report message to a moderator

Previous Topic:	Changing screen look
Next Topic:	DropDown Field values - changing in runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 01 02:22:13 EDT 2024

Total time taken to generate the page: 0.01160 seconds