Форум

Welcome Guest! To enable all features please try to register or login.
kako dobiti polje pomoću SQLexp sa forme za izbor kriterija na ispis
Options Go to last post Go to first unread
Previous Topic Next Topic
HD_prijavio
#1 Posted : 03 March 2011 11:32:00(UTC)
HD_prijavio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 1

Was thanked: 2 time(s) in 2 post(s)
U jedno polje na izvještaju 222 želim ubaciti SQL upit koji se poziva na datum iz kriterija pod nazivom: "Datum stanja:". Kako da dobijem to u izvještaju?
Znaći htio bih: select * from tablica where datum = ("Datum stanja") - polje. Hvala.
HD_odgovorio
#2 Posted : 03 March 2011 11:32:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)
Pozdrav,

Podatak uzmemo direkno sa unosne forme sa upotrebom funkcije GetFormValue.
Gornji red ispiše datum stanja u formatu yy/mm/dd, a donji u formatu dd.mm.yyyy:
[GetFormValue(`osSreIzpis.fDatum`)]
[Copy(GetFormValue(`osSreIzpis.fDatum`),9,2)].[Copy(GetFormValue(`osSreIzpis.fDatum`),6,2)].[Copy(GetFormValue(`osSreIzpis.fDatum`),1,4)].
HD_odgovorio
#3 Posted : 03 March 2011 11:32:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)


Ali kako to polje ubaciti u SQL upit za neko polje?<br>Trebam znaći:<br>[SQLExp(`select acKey from the_move where adDate = ¨DATUMA S KRITERIJA - DATUM STANJA¨ `)]
HD_odgovorio
#4 Posted : 03 March 2011 11:32:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)

Pozdrav,

Evo:

[SQLExp(`select acKey from tHE_Move where adDate = ``` + GetFormValue(`OsSreIzpis.fDatum`) + ````)]

HD_odgovorio
#5 Posted : 03 March 2011 11:32:00(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)


Thx.
Rss Feed  Atom Feed
Users browsing this topic
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-2025, Yet Another Forum.NET
This page was generated in 0,084 seconds.