1. Helge Tjelta
  2. Valentina Studio
  3. Monday, August 12 2019, 06:30 PM
  4.  Subscribe via email
Recently I have tried different newer versions of studio, and one thing I don't understand.

When a table is linked via object pointer, this would work in the data editor this way.
Select a record in on table and the linked records would get selected in the related table.
This works nicely in v.7.5.9

Moving on to v8 and v9, there is now records showing in the related table, when using show linked is the mode... why?

Am I doing something wrong. Opening the same database in both, shows me different behavior of newer versions of studio. What is going on?
Comment
There are no comments made yet.
Helge Tjelta Accepted Answer
Using Show all MODE, then the related record is highlighted. But not in the newer versions.
Comment
There are no comments made yet.
Helge Tjelta Accepted Answer
Some typos in the first post here...

What I meant to write was, when selecting in the first table, the linked record would show in the related window...
And by v8 and v9, there is NO records showing at all.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Helge,

I'll check what is wrong shortly, thank you.
It should work the same way.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Can't reproduce for now.

Can you show the SQL for the linked tables?
Comment
There are no comments made yet.
Helge Tjelta Accepted Answer
-- Valentina 7 SQL dump --
----------------------------------------------------
;

-- Create database
-- Note - the database creation will be skipped in case of database exists
-- But SET PROPERTY will be applied anyway
----------------------------------------------------
;

CREATE DATABASE IF NOT EXISTS [timereg] WITH
SET PROPERTY
[Mode],
[IdentsCaseSensitive],
[SegmentSize],
[SchemaVersion],
[DateTimeFormat],
[DateSeparator],
[TimeSeparator],
[KeyDelimiter],
[LocaleName],
[StorageEncoding],
[FrenchCollation],
[AlternateHandling],
[CaseFirst],
[CaseLevel],
[NormalizationMode],
[Strength],
[HiraganaQuaternaryMode],
[NumericCollation]
of DATABASE TO
'kDscDatBlbInd',
false,
32768,
1,
'kMDY',
'/',
':',
'.',
'nb_NO',
'UTF-16',
'kOff',
'kNonIgnorable',
'kOff',
'kOff',
'kOff',
'kSecondary',
'kOff',
'kOff';


;


USE [timereg];


-- Create KeyValues

-- Create types

-- Dump for 'Person' table
----------------------------------------------------
;

CREATE TABLE "Person" (
"Fornavn" VARCHAR (2044) ,
"Etternavn" VARCHAR (2044) ,
"Epost" VARCHAR (2044) ,
"Telefon" VARCHAR (2044) ,
"Kontonr" VARCHAR (2044) ,
"Adresse" VARCHAR (2044) ,
"Postnr" VARCHAR (2044) ,
"Poststed" VARCHAR (2044) );









-- Create KeyValues


-- Dump for 'Firma' table
----------------------------------------------------
;

CREATE TABLE "Firma" (
"Navn" VARCHAR (2044) );


-- Create KeyValues


-- Dump for 'Timene' table
----------------------------------------------------
;

CREATE TABLE "Timene" (
"Tid_start" DATETIME ,
"Tid_slutt" DATETIME ,
"Avtale" ULONG );




-- Create KeyValues


-- Dump for 'Avtale' table
----------------------------------------------------
;

CREATE TABLE "Avtale" (
"Overtid_pr_time" BOOLEAN ,
"Overtid_pr_uke" BOOLEAN ,
"Overtid_pr_hviletid" BOOLEAN ,
"Timerate" DOUBLE (4,6) ,
"Dato_fra" DATE ,
"Dato_til" DATE ,
"Firma" ULONG ,
"Person" ULONG );









-- Create KeyValues


-- Dump for 'Medarbeider' table
----------------------------------------------------
;

CREATE TABLE "Medarbeider" (
"Fornavn" VARCHAR (2044) ,
"Etternavn" VARCHAR (2044) ,
"epost" VARCHAR (2044) ,
"telefon" VARCHAR (2044) ,
"Firma" ULONG );


SET PROPERTY
[comment]
of TABLE "Medarbeider" TO
'Dette er ansatte i firmaer som skal kunne ha oversikt over og lage avtaler. Skal kunne hente ut oversikt for sine ansatte/personer.'
;





-- Create KeyValues



-- Dump for 'lnk_Firma_Avtale' link
----------------------------------------------------
;

ALTER TABLE "Avtale" MODIFY Firma OBJECTPTR CONSTRAINT "lnk_Firma_Avtale" REFERENCES "Firma" ON DELETE SET NULL;




-- Create KeyValues



-- Dump for 'lnk_Person_Avtale' link
----------------------------------------------------
;

ALTER TABLE "Avtale" MODIFY Person OBJECTPTR CONSTRAINT "lnk_Person_Avtale" REFERENCES "Person" ON DELETE RESTRICT;




-- Create KeyValues



-- Dump for 'lnk_Timene_Timene' link
----------------------------------------------------
;

ALTER TABLE "Timene" MODIFY Avtale OBJECTPTR CONSTRAINT "lnk_Timene_Timene" REFERENCES "Avtale" ON DELETE RESTRICT;




-- Create KeyValues



-- Dump for 'lnk_Firma_Medarbeider' link
----------------------------------------------------
;

ALTER TABLE "Medarbeider" MODIFY Firma OBJECTPTR CONSTRAINT "lnk_Firma_Medarbeider" REFERENCES "Firma" ON DELETE SET NULL;
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Thank you, I added records to the tables, but the Data Editor shows the linked records.
Maybe you can run the Query Log from the main toolbar - no errors?
Attachments (2)
Comment
There are no comments made yet.
Helge Tjelta Accepted Answer
Hm, strange, I only get 0 columns and 0 records ?

Not like you, 1 record and 1 column...

Has this something to do with the version of the server ?
The server is running av v 7.3.4...Windows.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
So no errors just 0 records, 0 columns.
Yes, that's strange.

And if you execute JOIN manually it works, right?
Comment
There are no comments made yet.
Helge Tjelta Accepted Answer
I have just done test in with data editor in studio... no sql yet
Comment
There are no comments made yet.
Helge Tjelta Accepted Answer
In studio 9.1.4 I know get:
Kernel error: 0x7004. Using clause required for dynamic parameters.
Have not seen that before.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
There's a parameter in this query, so you can either replace it with RecID value or type the parameter value on the right panel.
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
SQL Editor of Valentina Studio allows you use SQL query with bind parameters, e.g.
SELECT ... WHERE fld = :1

On the right side you should see panel where you can enter values for each such parameter.
Comment
There are no comments made yet.
Helge Tjelta Accepted Answer
But why does it not work in data-editor view, as it did before... older version do it?
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Helge,

maybe we talking about different things ...
We did NOT remove any old features.

Maybe you can add screenshot ?
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
The older version used an API way which is fine for local database but may be slow on remote connections.

Valentina Server since version 9.0 uses significantly changed protocol, but it's strange that for some queries it returns a result, but not records/columns for the related table.

So what if you try to execute the JOIN query - replacing :1 placeholder with actual RecID value, or writing value in the parameters panel?
Comment
There are no comments made yet.
Helge Tjelta Accepted Answer
Turns out older server is the problem.

Upgrading to server 9.3.2 and running studio 9.3.2 worked perfect again.

But studio v8 or v9 will not work in the data-editor with 7.3.4 server.
Upgrading time.
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories