Rapor ve Form Tasarımlarında SQLINFO Kullanımı

Program içerisinde Rapor ve Form tasarımlarında Query’ ler ile farklı table’ lara ulaşmak için kullanılır.

Rapor tasarımında tanımlı alan içerisinde SQLINFO fonksiyondan sonuç METIN olarak denüyor.

Tanımlı alan türü metin olacak… Her field için tırnak işareti kullanılacak…

_SQLINFO (“Field”, “Table”, “Where”)

Örnek SQLINFO fonksiyon kullanımı

Cari Hesap Listesi raporunda Ödeme plan kodunun yanında Ödeme plan açıklamasının raporlanması.

_SQLINFO(“DEFINITION_”,”LG_003_PAYPLANS”,”CODE='”+[Ödeme plan kodu]+”‘”)

(SELECT DEFINITION_ FROM LG_003_PAYPLANS WHERE CODE=’P.01’)

Cari Hesap Listesi raporunda C/H Özel kodunun yanında C/H Özel kod açıklamasının raporlanması.

_SQLINFO(“DEFINITION_”,”LG_003_SPECODES”,”CODETYPE=1 AND SPECODE='”+[Cari hesap özel kodu]+”‘”)

(SELECT DEFINITION_ FROM LG_003_SPECODES WHERE CODETYPE=1 AND SPECODE=’S01’)

Genel Amaçlı Raporlar içerisinde 100 Kasa hesabı’ nın Hareket Borç toplam bilgilerine ulaşmak.

VAL(_SQLINFO(“SUM(S.DEBIT)”,”LG_003_EMUHACC AS H, LG_003_02_EMFLINE AS S”,”H.LOGICALREF=S.ACCOUNTREF AND H.CODE=’100′”))

(SELECT SUM(S.DEBIT) FROM LG_003_EMUHACC AS H, LG_003_02_EMFLINE AS S WHERE (H.LOGICALREF=S.ACCOUNTREF AND H.CODE=’100′))

Seri / Lot Envanter raporunda Son Kullanım tarihinin listelenmesi

Aşağıdaki alanlar tek tek tanımlı alan yapıldıktan sonra

[MALZ] = R1.logicalRef (Türü = Sayı )

[LINE] = R2.logicalRef (Türü = Sayı )

[LOT] = R4.logicalRef (Türü = Sayı )

(Türü = Metin)

_SQLINFO(“EXPDATE”,”LG_003_02_SLTRANS”,”STTRANSREF=”+STR([LINE])+” AND ITEMREF=”+STR([MALZ])+” AND SLREF=”+STR([LOT])+””)

Comments

JeaTeef - 5 Şubat 2019 at 12:49

Magasin Levitra vardenafil 20 mg.no prescription Kamagra Effet
air jordan cheap - 9 Şubat 2019 at 11:13

Appreciating the time and effort you put into your website and detailed information you offer. It’s awesome to come across a blog every once in a while that isn’t the same unwanted rehashed information. Excellent read! I’ve bookmarked your site and I’m including your RSS feeds to my Google account.
JeaTeef - 21 Şubat 2019 at 09:58

Levitra En Andorra cialis without prescription Achat Cialis En Suisse Pay With Check By Phone
JeaTeef - 11 Mart 2019 at 09:24

Dental cheapest cialis 20mg Amoxil Dosis Infantil
JeaTeef - 29 Mart 2019 at 06:51

5mg Of Propecia For Hair Loss Best Canadian Mail Order Pharmacies tadalafil cialis from india Comprar Cialis Valencia Zithromax Cost At Publix Pak Coupon
JeaTeef - 28 Nisan 2019 at 00:15

Buy Amoxicillin 875 Mg Amoxicillin Buy Rx Buying Cheap Flagyl Wholesale buy viagra online Vente De Cialis En France
StevQued - 14 Mayıs 2019 at 01:12

150 Mg Lithium Capsules cialis 5mg best price Cialis Generico Vendita In Italia Duphaston
StevQued - 2 Haziran 2019 at 17:32

Achat De Vrai Viagra Cialis Online Rush Delivery buy viagra Levitra Nitric Oxide Tafidil
Keldede - 3 Haziran 2019 at 00:29

Cialis 5mg Shop zoloft 100 mg no script and very cheap Amoxicillin Directions For Use Acheter Du Clomid En Ligne Effets Secondaires Generic Viagra Paypal Buy 240
LesImpest - 6 Haziran 2019 at 07:10

Priligy Laboratorio Venta De Viagra Para La Mujer viagra Toronto Drug Store Pharmacy Retin A Cream Amitriptyline Overnight No Rx
Keldede - 12 Haziran 2019 at 17:39

On Sale Generic Macrobid In Canada Store Overseas Acheter Du Clomid Tests De Grossesse Levitra 10 Mg Quanto Costa stendra priligy Purchasing Clonidine Viagra Pfizer Suisse Buy Propecia Online Canada
StevQued - 17 Haziran 2019 at 02:01

Commande Viagra Et Cialis Citalopram Pills For Sale zoloft canadian pharcharmy Cheap No Perscription Viagra
LesImpest - 19 Haziran 2019 at 21:47

Cialis Vs Viagra Cost isotretinoin free shipping Ou Acheter Du Viagra Librement antabuse for sale no prescription Medrol Dose Pack 4 Mg No Rx
Keldede - 25 Haziran 2019 at 12:17

Sublingual Viagra 150 Mg Propecia Achat Canada Viagra En Jovenes cialis from canada Comprare Viagra Generico Italia
StevQued - 30 Haziran 2019 at 22:46

Abc Pharmacy Canada Canine Cephalexin 500 Mg Plus Longtemps Au Lit. cialis online Cialis Prezzo 5 Mg Can You Buy Keflex Over The Counter
LesImpest - 4 Temmuz 2019 at 08:10

Cialis Dosierung 5 Mg No Pain Tooth Infection And Amoxicillin cialis Preisvergleich Cialis 20mg Filmtabletten Qi A Pris Du Cytotec
Keldede - 8 Temmuz 2019 at 13:57

Buy Nolvadex Tamoxifen Uk viagra prescription Priligy Cuanto Dura El Efecto zoloft
StevQued - 12 Temmuz 2019 at 09:44

Lecorea Cytotec Composition cialis 20mg for sale Cialis Lilly 20mg 12 Propecia 0.5 Mg Avodart
LesImpest - 17 Temmuz 2019 at 00:51

Amoxicilina Quick Shipping Cheap buy generic accutane online no prescription viagra Levitra Donde Comprar Why Cephalexin In Dogs Cialis Viagra Roma
Keldede - 21 Temmuz 2019 at 00:46

Can I Buy Cialis Online Priligy Zuzahlung buy cialis online Where To Buy Viagra In Nz Cheap Synthroid No Prescription