Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Objave: 1
Was thanked: 2 time(s) in 2 post(s)
|
Pokušavam slijedećim izrazom definirati grid na Ctrl-F ekranu:
Select A.acIdent, A.acName, A.acFieldSA, B.anLastPrice, A.anPrice, A.anRTPrice, A.anSalePrice, A.acFieldSB, A.acFieldSC, A.acFieldSD, A.acCode, A.acSetOfItem
From tHE_SetItem A, tHE_Stock B
Where (A.acIdent <> ' ') and (A.acIdent < '99') and (A.acIdent = B.acIdent) and (B.acWarehouse = 'Skladište Veleprodaja')
Order By A.acIdent
Međutim, polje je "prekratko" (izraz ne stane).
Kako to napraviti ?
|
|
|
|
|
|
Rank: Datalab
You have been a member since:: 14/08/2009(UTC)
Objave: 0
Was thanked: 1 time(s) in 1 post(s)
|
Pozdrav, Ako želimo upotrijebiti podatke iz različitih tablica, u tu svrhu moramo definirati view (u Management studiu, Enterprise manager, Query analyser), nikako ne u PAntheonu. Onda se u Pantheonu definira koja polja iz viewa želimo vidjeti. Više informacija na http://help.datalab.hr/p55/003086.html
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)Powered by YAF 1.9.6.1 Under DNN |
YAF © 2003-2026, Yet Another Forum.NETThis page was generated in 0,412 seconds.