• Registered: 2016-01-17
  • Posts: 144

Topic: no such column error

Hi
Every time I want to edit a record from the table grid this error is shown:
no such column: terminals.id_pictures
as you can understand I have 2 tables: terminals and pictures
I like to save my pictures in a separate table
In the field type section of the table terminals, I defined a relationship to the picture table and I didn't check the not null part.
what am I doing wrong?
by the way, if I save my pictures in a separate table, does it increase the speed of the loading of the project?
thanks

  • Registered: 2014-08-02
  • Posts: 918

Re: no such column error

Hello identify

Strange idea to store your images in a separa tetable
Why don't you  use property Type : LinktoFile and property CopyTo (ie \Covers)
It's more easy to manage your pictures.
Unless you have a specifiq reason to do so

JB

3 Reply by identity (edited by identity 2016-01-27 18:24:15)

  • Registered: 2016-01-17
  • Posts: 144

Re: no such column error

yes I have a very specific reason to do it
the reason is my version of this program is 1.45 and it does not have link file or copy to
now that you know my reason, could you please help me get rid of this error
thanks

  • Registered: 2014-08-02
  • Posts: 918

Re: no such column error

Hello Idntity

Welle it's a good reason
Why don't use in a script Delphi event CreateDir or better event ForceDirectory ?


Trying to  create nesed directory within curent directory :

  if CreateDir('C:\MyNewDirectory\MyDir)
  then ShowMessage('New directory added successfull')

To force it to create this directory :

  if forcedirectories('C:\MyNewDirectory\MyDir)')
  then ShowMessage('New directory added successfull'')
  else ShowMessage('Fail to create new directory')

To give a friendly look, you could use an OpenDialog.

To try

JB

  • Registered: 2016-01-17
  • Posts: 144

Re: no such column error

Hi jean.brezhonek
I didn't quite get the script. What does it do?
how can I use it? could you give me the whole script and tell me where to place this script?
thanks

  • Registered: 2014-02-14
  • Posts: 10,294

Re: no such column error

identity
Please attach your project (zip file without exe and dll)

Dmitry.