List Info

Thread: Liking sql and oracle
Liking sql and oracle
country flaguser name
United States		 1969-12-31 18:00:00 

  


  

    I am having trouble 
in an Access database which has a link to an oracle table.  When I look for 
a record which has leading spaces, the sql portion of the query drops the 
leading spaces which make the fields not match.  Is there any work around 
for this? ; I can change the sql side and anything in the Access database, I 
cannot effect changes in the oracle table.


Thank you for your assistance,


Julie 
Johnson
*****************************************************************************
This communication is for the use of the intended recipient only.  It may 
contain information that is privileged and confidential.  If you are not the 
intended recipient of this communication, any disclosure, copying, further 
distribution or use thereof is prohibited.  If you have received this 
communication in error, please advise me by return e-mail or by telephone and 
delete/destroy it.
*****************************************************************************

__._,_.___





__,_._,___

  

  
  
   
     
    

  

    RE:  Liking sql and oracle
  


  

     country flaguser name
United States		
     2007-03-05 13:02:29
  


  

    
Julie -- I believe there is a Trim function in Access SQL,
or possibly an LTRIM function, as there is in VBA...witch
you can use as a calculated field to check to see if the
data in Access matched your ORACLE table.
 
HTH
-=BDN=-

________________________________

From: helpwithvb@yahoogroups.com on behalf of Johnson,
Julie
Sent: Mon 3/5/2007 11:15 AM
To: helpwithvb@yahoogroups.com
Subject: [helpwithvb] Liking sql and oracle


.
I am having trouble in an Access database which has a link
to an oracle table.  When I look for a record which has
leading spaces, the sql portion of the query drops the
leading spaces which make the fields not match.  Is there
any work around for this?  I can change the sql side and
anything in the Access database, I cannot effect changes in
the oracle table. 

Thank you for your assistance,
Julie Johnson

 


------------------------ Yahoo! Groups Sponsor
--------------------~--> 
Something is new at Yahoo! Groups.  Check out the enhanced
email design.
http://us.click.yahoo.com/kOt0.A/gOaOAA/yQLSAA/k7folB/TM

------------------------------------------------------------
--------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://grou
ps.yahoo.com/group/helpwithvb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://
groups.yahoo.com/group/helpwithvb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:helpwithvb-digest@yahoogroups.com 
    mailto:helpwithvb-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    helpwithvb-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/
 



  


  

    
  

  
  
   
     
    
 
        
    

    
    

  

    Re:  Liking sql and oracle
  


  

     country flaguser name
United States		
     2007-03-05 20:02:10
  


  

    

  


  

    



!FirstName = "" & 
Trim$(txtFName.Text)


 


this works just great


and thank you to whoever gave it to me


Mike B


 


dwight



  
----- Original Message ----- 

  
  
  
Sent: Monday, March 05, 2007 12:02 
  PM

  
Subject: RE: [helpwithvb] Liking sql and 
  oracle

  


  

  
Julie -- I believe there is a Trim function in Access SQL, or possibly an 
  LTRIM function, as there is in VBA...witch you can use as a calculated field 
  to check to see if the data in Access matched your ORACLE 
  table.

HTH
-=BDN=-

________________________________

From: 
  helpwithvbyahoogroups.com 
  on behalf of Johnson, Julie
Sent: Mon 3/5/2007 11:15 AM
To: helpwithvbyahoogroups.com
Subject: 
  [helpwithvb] Liking sql and oracle

.
I am having trouble in an 
  Access database which has a link to an oracle table. When I look for a record 
  which has leading spaces, the sql portion of the query drops the leading 
  spaces which make the fields not match. Is there any work around for this? I 
  can change the sql side and anything in the Access database, I cannot effect 
  changes in the oracle table. 

Thank you for your assistance,
Julie 
  Johnson


__._,_.___





__,_._,___

  

  
  
   
     
    

  

    RE:  Liking sql and oracle
  


  

     country flaguser name
United States		
     2007-03-06 08:02:04
  


  

    
You're welcome
-=BDN=- (Bruce Neiger)
 
-----------
!FirstName = "" & Trim$(txtFName.Text)
 
this works just great
and thank you to whoever gave it to me
Mike B
 
dwight
________________________________

From: helpwithvb@yahoogroups.com on behalf of Dwight Norris
Sent: Mon 3/5/2007 8:02 PM
To: helpwithvb@yahoogroups.com
Subject: Re: [helpwithvb] Liking sql and oracle


.
 
 


------------------------ Yahoo! Groups Sponsor
--------------------~--> 
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/0It09A/bOaOAA/yQLSAA/k7folB/TM

------------------------------------------------------------
--------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://grou
ps.yahoo.com/group/helpwithvb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://
groups.yahoo.com/group/helpwithvb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:helpwithvb-digest@yahoogroups.com 
    mailto:helpwithvb-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    helpwithvb-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/
 



  


  

    
  

  
  
   
     
    
 
        
    

    
    

  

     Using VB forms in HTML
  


  

     country flaguser name
United States		
     2007-03-06 13:44:32
  


  

    
This is one of those question that may sound dumb for those
who are fluent
in HTML.  Can a form that is created in VB be used in HTML
by using
VBScript and the text version of the form?  Example:

<script type="text/vbscript">
Begin VB.Form frmMyForm
   BorderStyle     =   1  'Fixed Single
   Caption         =   "Test Form"
   ClientHeight    =   8400
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   10485
End

</script>



------------------------ Yahoo! Groups Sponsor
--------------------~--> 
Something is new at Yahoo! Groups.  Check out the enhanced
email design.
http://us.click.yahoo.com/kOt0.A/gOaOAA/yQLSAA/k7folB/TM

------------------------------------------------------------
--------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://grou
ps.yahoo.com/group/helpwithvb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://
groups.yahoo.com/group/helpwithvb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:helpwithvb-digest@yahoogroups.com 
    mailto:helpwithvb-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    helpwithvb-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/
 



  


  

    
  

  
  
   
     
    






 [1-5]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )