1. Helge Tjelta
  2. Valentina Studio
  3. Montag, August 12 2019, 06:30 PM
  4.  Abonnieren via E-Mail
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?
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
Using Show all MODE, then the related record is highlighted. But not in the newer versions.
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Helge,

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

Can you show the SQL for the linked tables?
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
-- 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;
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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?
Anhänge
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
So no errors just 0 records, 0 columns.
Yes, that's strange.

And if you execute JOIN manually it works, right?
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
I have just done test in with data editor in studio... no sql yet
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
In studio 9.1.4 I know get:
Kernel error: 0x7004. Using clause required for dynamic parameters.
Have not seen that before.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
But why does it not work in data-editor view, as it did before... older version do it?
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi Helge,

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

Maybe you can add screenshot ?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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?
Kommentar
There are no comments made yet.
Helge Tjelta Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  • Seite :
  • 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