1. Helge Tjelta
  2. Valentina Studio
  3. 月, 8月 12 2019, 06:30 PM
  4.  メールで購読
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?
コメント
There are no comments made yet.
Helge Tjelta 承諾済みの回答
Using Show all MODE, then the related record is highlighted. But not in the newer versions.
コメント
There are no comments made yet.
Helge Tjelta 承諾済みの回答
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.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Helge,

I'll check what is wrong shortly, thank you.
It should work the same way.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Can't reproduce for now.

Can you show the SQL for the linked tables?
コメント
There are no comments made yet.
Helge Tjelta 承諾済みの回答
-- 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;
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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?
添付ファイル
コメント
There are no comments made yet.
Helge Tjelta 承諾済みの回答
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.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
So no errors just 0 records, 0 columns.
Yes, that's strange.

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

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

Maybe you can add screenshot ?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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?
コメント
There are no comments made yet.
Helge Tjelta 承諾済みの回答
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.
コメント
There are no comments made yet.
  • ページ :
  • 1


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