Print Thread
Code Assistant: rows change order when I type
#65525 03/15/24 03:41 PM
Joined: Nov 2023
Posts: 45
G
Member
OP Offline
Member
G
Joined: Nov 2023
Posts: 45
I write "<table>." and get a list of all the columns, with user_id first.
I write "<table>.u" and now user_comment is first with user_id second.

I'm guessing you're using column order first, and then sort order?

Also: When I've maximized the window and write at the bottom, the list of suggestions is in the way; It goes across of where I'm writing.
Looks like you're placing it below and then it is pushed up?

Re: Code Assistant: rows change order when I type
guttormvik #65528 03/18/24 10:49 AM
Joined: Aug 1999
Posts: 22,212
Member
Offline
Member
Joined: Aug 1999
Posts: 22,212
Quote
I write "<table>." and get a list of all the columns, with user_id first.
I write "<table>.u" and now user_comment is first with user_id second.

I'm guessing you're using column order first, and then sort order?
When no partial column name is typed, the complete list is presented. By default in physical order, but you can change it to alphabetical order by clicking on the sort button at the bottom. This sort order is persistent.

When you type a "u", everything that includes a "u" is presented. Column names that start with a "u" are listed first. This is indeed in alphabetical order.

Quote
Also: When I've maximized the window and write at the bottom, the list of suggestions is in the way; It goes across of where I'm writing.
Looks like you're placing it below and then it is pushed up?

The list in indeed kept "on-screen". We'll see if we can correct the situation where it will block your own text. Probably the list should be one character to the right, so that your text and the cursor remain visible.


Marco Kalter
Allround Automations
Re: Code Assistant: rows change order when I type
guttormvik #65550 03/21/24 09:48 AM
Joined: Nov 2023
Posts: 45
G
Member
OP Offline
Member
G
Joined: Nov 2023
Posts: 45
Quote
the sort button at the bottom
I didn't even see that grin

Physical order is great, since the PK is normally at the top, so I don't think I want to always have the list sorted.
I seems weird that you sort the list when I start typing.
The logical thing would be to keep whatever order the list had, and just filter it.


Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 15 (0.009s) Memory: 2.5048 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-05-09 04:59:40 UTC
Valid HTML 5 and Valid CSS