mibuso.com

Microsoft Business Solutions online community
It is currently Mon May 20, 2013 9:22 pm

View unanswered posts | View active topics


Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » Navision Attain

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 2 posts ] 
  What's this MUID? [MUID:5AIP] Previous topic | Next topic 
Author Message
Magno
 Post subject: upper
PostPosted: Thu Dec 09, 2004 12:12 pm 
Offline

Joined: Mon Oct 11, 2004 1:09 pm
Posts: 123
Location: Landen
Country: Belgium (be)
Hi,

I know with sql you can use upper and lower in your sql statement like:
sql = "select * from tbl where upper(field)='" & ucase(value) & "'"

i just can't make it work with codbc, could anyone help me on this one?
i want to make login non case sensitive, but i can't change fields in navision, so it has to be done in asp code
Top
 Profile  
 
Mark S
 Post subject:
PostPosted: Tue Dec 14, 2004 10:35 am 
Offline

Joined: Wed Nov 10, 2004 12:14 pm
Posts: 16
Location: Nijmegen
Country: Netherlands (nl)
try:

UCASE (string_exp)

_________________
M Stunnenberg
GAC Business Solutions B.V.

Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 2 posts ] 

Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » Navision Attain

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: