It took a while to figure out that the column names must be quoted. I had to look in my SqlQuery.prg code to see how I did it 2 years ago.
I forgot.
This is correct syntax:
ALTER TABLE mn_drv
ALTER COLUMN "user" "usr" char(10)
Search found 4769 matches
- Sun Oct 01, 2023 8:00 pm
- Forum: Xbase++ 2.0
- Topic: How to ALTER a Column using ADS SQL
- Replies: 2
- Views: 2795
- Sun Oct 01, 2023 7:47 pm
- Forum: Xbase++ 2.0
- Topic: How to ALTER a Column using ADS SQL
- Replies: 2
- Views: 2795
How to ALTER a Column using ADS SQL
The Advantage documentation for ALTER TABLE ALTER COLUMN is terrible.
I want to use SQL to change a field name but cannot figure out a syntax that works.
We have a lot of fields in a lot of tables that need to be changed from USER to USR.
Any ideas?
I want to use SQL to change a field name but cannot figure out a syntax that works.
We have a lot of fields in a lot of tables that need to be changed from USER to USR.
Any ideas?
- Mon Sep 18, 2023 4:18 pm
- Forum: eXpress++ Support
- Topic: Error DC_POPDATE when using keyboard
- Replies: 6
- Views: 2679
Re: Error DC_POPDATE when using keyboard
Sorry, I didn't go back far enough in the thread to see that you already had a solution.This is about the same modification as I did. See the first post. I added all the parameters.
- Mon Sep 18, 2023 6:45 am
- Forum: eXpress++ Support
- Topic: Error DC_POPDATE when using keyboard
- Replies: 6
- Views: 2679
Re: Error DC_POPDATE when using keyboard
Here is a fix: _DCCALEN.PRG, starting at line 565: ELSEIF mp1 = xbeK_ESC _DCCalen2(aPopDate,DCCALEN_ABORT,,,,nScale) lOk := .f. ELSEIF mp1 = xbeK_ENTER _DCCalen2(aPopDate,DCCALEN_EXIT,,,,nScale) ELSEIF _DCHotKey( DC_LangMsg(DCMSG_OK), mp1) _DCCalen2(aPopDate,DCCALEN_EXIT,,,,nScale) ELSEIF _DCHotKey(...
- Fri Sep 15, 2023 7:51 am
- Forum: eXpress++ Support
- Topic: Error DC_POPDATE when using keyboard
- Replies: 6
- Views: 2679
Re: Error DC_POPDATE when using keyboard
I could only make it error when pressing the ESC key.
Tell me how you are using it and what keys are giving errors.
Tell me how you are using it and what keys are giving errors.
- Thu Sep 14, 2023 9:35 am
- Forum: Announcements
- Topic: BBS seems to be back up..
- Replies: 8
- Views: 5196
Re: BBS seems to be back up..
I still think that was some kind of Windows 10 problem, because the attachments did exist and the SQL data looked ok.If now the problem with no access to the attachments will be solved, that would be really nice
I haven't heard that this is still a problem.
- Wed Sep 13, 2023 9:29 am
- Forum: phpBB Board Support
- Topic: Forum is back online
- Replies: 0
- Views: 6695
Forum is back online
I apologize for the forum outage for 2 weeks. I had no idea that so many of you were missing visiting my server in Boise, Idaho, USA. The server missed all of you too. It couldn't understand why it was in the wilderness for so long. When battling the problem, I had to relearn something that I unders...
- Wed Sep 13, 2023 9:13 am
- Forum: Announcements
- Topic: BBS seems to be back up..
- Replies: 8
- Views: 5196
Re: BBS seems to be back up..
We all missed you too, Tom.I missed the board.
- Wed Sep 13, 2023 9:12 am
- Forum: Announcements
- Topic: BBS seems to be back up..
- Replies: 8
- Views: 5196
Re: BBS seems to be back up..
My new internet service is about 10 times faster on download as before.it feels faster
I'm not sure what the speed is now on upload but I know it's faster.
Upload speed is what you feel.
- Tue Sep 12, 2023 3:33 pm
- Forum: Announcements
- Topic: BBS seems to be back up..
- Replies: 8
- Views: 5196
Re: BBS seems to be back up..
I could have resolved this days ago if I had remembered that my .htaccess file for Apache had all the redirects I needed. I didn't need all the static IPs back, only 1 static IP and Apache. This is probably why CenturyLink no longer offers blocks of static IPs. The day I move my service to a new add...