ORACLE: Field Lenght!
Hello!
for the first time, i'm using ORACLE DB with my VB Project.
I find a little problem, with CHAR field:
1) i open my recordset
2) i set datasource and datafield of my textbox
3) the value the DB ORACLE have, after my digits, is a string of the dimension of the DB Field Size!
if i write: "HELLO"
i'll find in the field:"HELLO "
not very nice
any knows hot to store value dimensioned by my digits, not by field size?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Field Lenght
Does DBGrid have a max. field lenght property? (just like MaxLenght propery in TextBoxes)
If not, could this be done by code?
Update Oracle Field
Hi All:
I need to write a quick app to simply update a field in an oracle table, basically just connect to the db and do an update statement. any pointers on how to do this would be greatly appreciated!
thanks in advance!
//brett
How To Set Textbox To An Oracle Field
I have a textbox and I want to set my textbox to a field in my Oracle database. My table name is cama and
the field that I want my textbox set to is (p_city)
Can any one help me on this issue?
thankyou
this is what I have right now
Private Sub Form_Load()
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim txt As String
Dim fld As Field
' Open a connection using Oracle ODBC.
Set conn = New ADODB.Connection
conn.ConnectionString = _
"Driver={Oracle in OraHome92};" & _
"UID=sirron;PWD=linton"
conn.Open
' Open the table.
Set rs = New ADODB.Recordset
rs.Open "cama", conn, adOpenDynamic, adLockOptimistic, adCmdTable
Put A Date Into An Oracle Table's Field?
I had a project that was using SQL, and then had to modify it to put a date into a field, going from MS Access to Oracle. Here is what the code looked like:
strSQL = ""
strSQL = strSQL & "INSERT INTO MasterPN "
strSQL = strSQL & "(PN, Description, FSCM, "
strSQL = strSQL & "ATAPN, ESDS, SPN, "
strSQL = strSQL & "Keyword, CompVal, DimData, ModUser, ModDate) "
strSQL = strSQL & "VALUES ('" & rsTemp!PN & "', '" & strDescription & "', '" & rsTemp!Fscm & "', "
strSQL = strSQL & "'" & strATAPN & "', " & intESDS & ", '" & strSPN & "', "
strSQL = strSQL & "'" & rsTemp!Keyword & "', "
strSQL = strSQL & "'" & rsTemp!CompVal & "', '" & rsTemp!DimData & "', "
strSQL = strSQL & "'SYSTEM'" & Now()
conOracleDb.Execute strSQL, , adExecuteNoRecords
This did not place a date into the desired field. So, I deleted that piece of code and put in the following code:
strSQL = ""
strSQL = "SELECT * From MasterPN"
rsPart.Open strSQL, conOracleDb, adOpenStatic, adLockOptimistic, adCmdText
If Not (rsTemp.EOF = True And rsTemp.BOF = True) Then
rsPart.MoveLast
rsPart.AddNew
rsPart!PN = rsTemp!PN
rsPart!Description = rsTemp!Description
rsPart!Fscm = rsTemp!Fscm
rsPart!ATAPN = rsTemp!ATAPN
rsPart!ESDS = rsTemp!ESDS
rsPart!SPN = rsTemp!SPN
rsPart!Keyword = rsTemp!Keyword
rsPart!CompVal = rsTemp!CompVal
rsPart!DimData = rsTemp!DimData
rsPart!ModUser = "SYSTEM"
rsPart!ModDate = Now()
rsPart.Update
End If
And that code worked!! My question...... can anyone tell me why one way doesn't work but another way using the same Now() function does work? This one drove me nuts for the better part of a day.
Are there issues between MS Access date functions and date items in Oracle?
Any help and advice on this will be greatly appreciated. Thanks!!
Added green "resolved" checkmark - Hack
Problem With Oracle BLOB Field In VB
Hi,
I have a VB 6.0 application with a backend Oracle 8i Database.
A piece of code in this application is throwing me an error:
Err.Number = -2147467259
Err.Description = Data Type is not supported.
I must mention the following:
1) I am using Microsoft ActiveX Data Objects 2.6 Library
2) The DB has a table named MyPicTable with the following structure:
Code:
Create Table MyPicTable
(
Pic_ID NUMBER(10)
, Pic_Image BLOB
)
3) I am using MSDORA as connection Provider as follows:
(I must mention that I am getting a connection to the DB! That's OK! Also, using this connection string is a compulsion!!)
VB Code:
' ************************************************** *********' serverName, dbUID, dbPWD are variables defined elsewhere ' serverName will be in the format 127.0.0.1ConnectStr = "Provider=MSDAORA;Server=" & serverName & ";User ID=" & dbUID & ";Password=" & dbPWD & ";"Set myConn = New ADODB.ConnectionWith myConn.ConnectionString = ConnectStr.CursorLocation = adUseClient.OpenEnd With ' ************************************************** *********Dim myRS As New ADODB.RecordsetDim strSelectSQL As String Set myRS = New ADODB.RecordsetstrSelectSQL = "SELECT * FROM MyPicTable WHERE 1=2" ' This line of code causes the error' Err.Number = -2147467259' Err.Description = Data Type is not supported.myRS.Open strSelectSQL, myConn, adOpenForwardOnly, adLockOptimistic
Could anyone kindly throw some light as to why the application is throwing this error...
Thanks in advance,
Nilanjan.
ADO Default Field Values For Oracle
I'm having a problem getting default field values from an ADO recordset using Microsoft's ADO Provider. I'm 90% certain I saw this work at some point, but I just can't figure out how to get it to work now. Basically, what I would hope to see is that when I do a .AddNew on the ADO recordset, fields that have a default value would already be populated in the recordset. Here's a piece of code that I am using:
m_oConnection.ConnectionString = _
"Provider=MSDAORA.1;Password=PASSWORD;User ID=USER;Data Source=ALIAS"
m_oConnection.CursorLocation = adUseClient
m_oConnection.Open
Set m_oRS = New Recordset
m_oRS.ActiveConnection = m_oConnection
m_oRS.CursorType = adOpenDynamic
m_oRS.Source = "select * from TABLENAME"
m_oRS.Open
m_oRS.AddNew
================
At this point I would expect to see the database column defaults in the field, but do not. Any suggestions?
Thanks in advance,
Tom
Ado Retreive Zero Value To Number Oracle's Field
Hello,
I'm working with VB 6.0, and try to query (through ADO) an ORACLE database (OLE-DB for ODBC) all works fine except Number fields. Indeed they're always retreived with a Zero value.
Anybody meet the strange error ?
Sorting A Field In Oracle Table?
When i am insering a record through VB6 form to oracle table, the last record i have entered is not saved as the last row, rather it is saved anywhere such as a 3rd or 4th row. I have used OLEDB MSDAORA provider and ADO 2.1. Can u solve these problem?
Another topic is how can i make indexed ( duplicates or no duplicates) a field in Oracle in design time of the table like Access? I am new in Oracle plzz Help me
Searching An Oracle 9i CLOB Field
We've written our own call tracking system here at work using VB6 and Oracle 9i. I've been thinking about adding a new bug - err feature that will allow users to search the Comment fields, which is a CLOB type field, in the database for any older tickets to see if someone else had the same problem and if so, how is was fixed. The comment fiels is just text so the idea is that a user can click a button in the app, key in what they want to look for and the app will search the comment field for all the records and return a listing of those tickets. Simple enough till I start hearing that searching CLOB fields doesn't work well.
Anyone else out there doing anything like this before I start pounding my head into the table trying to figure it out?
Thanks for any info..
Mike Godwin
KB8TRM - 40°08'2.202"N 82°54'20.491"W
http://www.mikegodwin.com
Visit my website or the terrorists win!
Addition To Date/time Field In Oracle
Hi Guyz,
Q1
Lets say i have the following data in the date time field..
6/25/2004 7:02:31 AM
How do i add another 8000seconds to this data in oracle?
Q2
And how do i search, for an example, give me all the list of data with 6/25/2005, no matter what time it is.
I tried using the like operator but it doesnt seem to work..
Any ideas?
thankx in advance
How To Insert A Date Field In Oracle Table
I am using VB5 and oracle as backend I want to insert a date value in a date field of a table. what insert statement shoud i use??
i tried number of permutations.
e.g.
sqlstr = "insert into customerqry(cid,Billing_End_Date) values(1, " & Format("20/11/1999", "short date") & ")"
it is giving me errror.
please anyone help me. it is a bit urgent.
thyanx in advance
Trouble Inserting Number Field With Precision In Oracle 8.1.5 DB
I am accesing OracleDb 8.1.5 version using ADO objects in VB. I am able to insert, update and delete records in Oracle DB but when the field is number datatype like(number(10,2)) , I m not able to insert into this field . I am using the following code.
Private Sub Command1_Click()
Dim cn As new ADODB.Connection
Dim rs As new ADODB.Recordset
Dim strConnection As String
Dim strSQL As String
cn.CursorLocation = adUseClient
strConnection = "DSN=TEST;UID=scott;PWD=tiger"
cn.Open strConnection
strSQL = "select * from numbertest"
rs.Open strSQL, cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!C1 = 101.5
rs.Update
Set rs = Nothing
End Sub
I am using the Microsoft ODBC Driver for Oracle.
It works fine with the Insert command but it fails for above code.
Can anyone help me with this problem..?
It gives the following error .
"[Microsoft][ODBC driver for Oracle][Oracle]ORA-01722: invalid number" error .
Grouping Records By Month In Oracle PL/SQL From DATE Field
Hi,
I'm sorry if this was posted before. I searched around and didn't see anything that answers my question. So if this is a repeat, sorry.
I have an Oracle table with a DURATION column and a DATE column. The dates are stored as '1/1/0001 12:00:00 AM' format and the durations are stored as Doubles. I'm trying to write a query that returns the SUM of the duration GROUP BY month. So far, here's what I've got:
Code:SELECT DATE, SUM(DURATION) AS DUR
FROM table
WHERE DATE BETWEEN TO_DATE('1/1/2000', 'MM/DD/YYYY') AND TO_DATE('12/31/2000', 'MM/DD/YYYY')
GROUP BY TO_DATE(DATE, 'MONTH, YYYY')
This version doesn't seem to work. If anyone can help straighten this out I'd really appreciate it!
-DDennison
Actual Size Of The Data In A LONG RAW (oracle Blob) Field
Hi,
I'm going crazy. I want to find out the actual size of the data which is stored in a long raw oracle field. I know how to read and write data to a long-raw field with the Get- and Append-Chunk methods. this works fine as long as you the file length stored separately in another field in this table to input it to the getchunk method. but i dont want to have to input the size - i mean the data is already saved in the long-raw field so why should i additionally supply it from outside.
the property ActualSize for example delivers a wrong value. Theres also a property called DefinedSize which is the max size of the long-raw. But how to get the data size?
Can yomebody help me?
Saving And Retrieving Text Rpts Into A Long Raw Field (Oracle)
Hi,
What is the quickest way to insert a report (word doc imported into a rich textbox control) using ADO into a long raw (Oracle) field? Would you recommend the stream object without Append/Get Chunk, vice versa, or the use of both. If you have done this yourself, any insight will be greatly appreciated - especially if you were able to do so with little difficulty! I have used ideas from Microsoft's support site (using the append/getchunk methods), however, am getting garbage along with the text. I have run out of ideas.
Thanks!
Getting Lenght Of Text
Hi folks,
How can i get the length of the text in a textfield?
i mean i want when the max letters are put in the textbox that it goes to the next but i don't know how to count the string
String Lenght
Hi,
How can I get the number of characters in a string but exclude space?
Midi Lenght???
I have this code
Code:
Private Declare Function mciSendString Lib "winmm.dll" Alias "mciSendStringA" (ByVal lpstrCommand As String, ByVal lpstrReturnString As String, ByVal uReturnLength As Long, ByVal hwndCallback As Long) As Long
dim Length as string*128
dim error as long
Error = mciSendString("open " & MyPath & Type & "alias song", 0, 0, 0)
Error = mciSendString("status song length", Length, 128, 0)
With this code I can get the lenght of a song. It works with Wav and mp3-files, but it doesn't work with mid-files. Can someone explain this
How To Get Mp3 Song Lenght
Hi all!
At now I can get all mp3 info (version, Layer, bitrate, sample rate etc.)
But how from this calculate time lenght of song in seconds?
Get Lenght Of A Wav/midi/mp3 ?
Hi.
Does anyone have a way to get the lenght of a sound file (it could be a wav, midi or mp3) ?
I know that i can do this with the media player control but i dont want to...
Thanks!
String Lenght
I have a string that is always going to be 1 character lenght. Can I specify to reserve only that lenght and will i save space in the memory?
CD Track Lenght
I'm making another program, a CD Player. I got most code from reading the MSDN liabrary on VB Help, so I got things like play, stop, eject, etc. to work, now what I would like to do is make 2 lines (line1 & line2) example:
___|________________
****|
(*'s dont count, I just need then to take up room)
the line accross is line1, and the one that is vertical is line2, now how do I get line2 to show at what place in track, the user is at now.
If you dont know what I'm trying to say, you know how the Real Player has the thing that shows at what part of the song the thing is at, well I'm trying to make that for my program
thanks in advance
[Edited by dimava on 07-14-2000 at 08:45 PM]
Zero Lenght Strings
I tried the following code:
For I = 1 To 6
If Adodc1.Recordset(Notes(I)) <> txtNotes(I) Then
Adodc1.Recordset(Notes(I)) = txtNotes(I)
End If
Next I
Notes(I) is a string array that contains the field names of an ACCESS database
txtNotes(I) is an array of TextBoxes (on a form)
The effort is an attempt to update the fields with the data contained in the TextBoxes.
I get an error if the txtNotes(I) Textbox is empty.
I tried a Null, but it didn't like that either!
Any clues as to how to keep the field empty ... so far my only solution has been to place a single space
( " " instead of a "" )
Bob
Lenght Of New Mail Message
I send emails to mobile phones pretty frequently and I'd like to have a macro that will test the length of the current body text against a number to let me know if it's too long or not. The problem is that I don't know how to get the text of the current new mail message. I'd like to pass it to something like this.
Sub testLength()
Dim max As Integer
max = InputBox("What's the max length?")
If Len(CurrentMail.Body.Text) > max -1 Then
MsgBox "Too Long, need to delete " & n & " characters
Else
MsgBox "Good to Go."
End If
End Sub
Obviously I've not worked it out, but I think you get the point. Problem is I need to know hwo to get "CurrentMail.Body.Text" or whatever it's actually called. I understand I can do it by creating a custom form and sending the message myself, but I'd rather just add a macro to the existing New Mail form. Any help would be appreciated, most examples I've seen of the Outlook object model show creating a new mailitem, but I just want to get a handle on the existing one.
List + VbTab Can Fix Lenght?
Hello, Can you help me that
(List) Styles = (Listview) styles
Because I try use
List1.AddItem (L1 & vbTab & L2 & vbTab & L3 & vbTab & L4 & vbTab L5)
But my
L1 max:Len(6)
L2 max:Len(10)
L3 max:Len(20)
L4 max:Len(10)
L5 max:Len(20)
But try to vbTab tha column is can't fix
any idea can fix it.
BTW: If my value is over Len(char), can automatic changed "..."
Yes, if use Listview is very easy, But List is same do it ?
API is good ?
P.S. I try changed font to FIX,Courier Font , and if
each value < max(len) I will add space " " to fix.
but if use space " " method, When need return value, how to deleted that " " ?
echline() = Split(List1.ListSelected, vbTab)
...
Please!
Cycle Lenght For Rnd() Function
hi there .......
any guru or master out there know how much is the cycle lenght for visual basic function Rnd() .... ??????
ASAP
Getting Full Lenght Username
I'm trying to get the full length username , but I don't know how.
I'm able to get the username with the api GetUsername( ),
but it gives me somthing like that : SmithJ
But what I want to get is : John Smith.
I'm working under win NT 4.0
I want to know if there's a way to get this..
Lenght Of Caption Bar On A Form?
is it possible to find out the lenght at run time of the caption bar on a form? what I want to do is send two pieces of text to a routine that works out how many spaces to put between the 2 strings to enable the start of the first piece of text at the start of the caption and the end of the 2nd string to finish at the end of the caption,no matter how long the 2 strings are. I hope I'm making sense here
Problem With Lenght Numbers
Hi guys i am making a program for myself (phonebook) and i found this example on the forum here. On my first form i have a command button that open form 2 and also i have a textbox with a listbox. So if i want to add a new numbers i click on my command form on page1 and this open form2 and into form 2 i put my numbers but i am limitied to 30 numbers only is there anyway that i can have infinit instead...
here is the code
FORM1--------------
'Declare udt
Private Type PhoneBook
strName As String * 30
strNumber As String * 30
End Type
I would like to adjust the 30 to infinit-------------
here is what i have on form 2 where i add my numbers
Private Type PhoneBook
strName As String * 30
strNumber As String * 30
End Type
Get A String Of Unknown Lenght ?
I have a string similar in form to this “12345 RTYUICK 4566/45679/23456789/2344/677”
But the real one will be different each time my runs, what I want to do is get the part of the string between the first two “/” do some calculations on it and put it back. Now in the example above “/45679/” the bit I need is the “45679” but in my app this could be “/1/” or up to “/100000000/”
So I need to say something like goto the first “/” and grab all there is until the next “/”
Is this possible? If so how?
Lenght Of A Byte Variable...?
Based on the code:
Code:
Dim myData() as Byte, myFile as String
myData() = INet1.OpenURL("http://www.server.com.br/file.zip", icByteArray)
While INet1.StillExecuting
DoEvents
Wend
myFile = App.Path & "file.zip"
Open myFile For Binary Access Write As #1
Put #1, , myData()
Close #1
How to check the file lenght?
I mean, when the URL "http://www.server.com.br/file.zip" does not exist, it creates an empty "file.zip".
How to delete the empty "file.zip" when it occurs?
Thanks (and sorry my English).
Deliminating Fix Lenght File
Let's say I have a file with the following data in it 1234000582564875
where the first 4 chars represent one field of data and the next 6 chars represent another field of data and so on. How can I parse such a field in Visual Basic?
How To Test The Lenght Of A Variable
Hi,
i have created a combobox called nouvcpte and the event 'keypress ' for testing the string a user types.
if the length of the string typed(the variable which contains this string is sPrefix)is <acclen(constant which value=5) then there is all the treatment after
if the length of sPrefix is >acclen and id the key he types on is 'enter' (keyascii=13)
then the procedure insertDB is executed.
the pb is i don't succed to enter in the condition Len(sPrefix)>5 and the insertion is never done.
the program stops after the message saying me the account is valid.
Could you have a look to my code, please, because it works on a little program(all the part after sPrefix=sPrefix&chr(keyascii) is not inserted inside it).
Thanks a lot again because i am tired to search.
Thanks a lot.
Nathalie
Code:
Public cn As ADODB.Connection
Private sPrefix As String
Private s As String
Private bCanSave
Private bValid
Const ACCLEN = 5
Dim i As Integer
Private Sub nouvcpte_KeyPress(KeyAscii As Integer)
Dim I As Integer
bValid = True
If Len(sPrefix) < ACCLEN Then
' si le caractère saisi est le Backspace alors
' '
If KeyAscii = 8 Then
If Len(sPrefix) > 0 Then
sPrefix = Mid(sPrefix, 1, Len(sPrefix) - 1)
End If
Exit Sub ' faire attention à ce exit sub
End If
'
For I = 1 To Combo1.ListCount - 1
'
s = Mid(Combo1.List(I), 1, ACCLEN)
'
'
'si la longueur de la chaîne déjà saisie =4(5-1) et que la concaténation de la chaîne déjà saisie et
'du caractère en cours = le nombre testé dans la comboliste
'
'
If Len(sPrefix) = ACCLEN - 1 And sPrefix & Chr(KeyAscii) = s Then
MsgBox "le nombre saisi existe déjà dans la liste des comptes ", vbExclamation
KeyAscii = 0
bValid = False
Exit For
Exit Sub
End If
'
' si la sous chaîne qui va du premier caractère du nombre testé dans la comboliste
'à son troisième au maximum est égale à la concaténation de la chaîne déjà saisie
'et du caractère en cours
If Mid(s, 1, Min(3, Len(sPrefix) + 1)) = sPrefix & Chr(KeyAscii) Then
bValid = True
' Exit For
End If
' 'La condition précédente ne peut plus être vérifiée si on a Len(sPrefix)+1 =4 donc on teste cette condition
'' pour pouvoir continuer
If Len(sPrefix) >= ACCLEN - 2 Then
bValid = True
' Exit For
End If
Next I
'
If bValid = False Then
KeyAscii = 0
MsgBox "le nombre saisi ne peut pas être inséré dans la base de données", vbExclamation
' Combo1.Text = ""
Else
' si la variable bValid= true alors on ajoute à la valeur de sPrefix celle du caractère en cours,
'
sPrefix = sPrefix & Chr(KeyAscii)
If Len(sPrefix) = ACCLEN Then
If CanAdd(Mid(sPrefix, 1, ACCLEN - 1)) = True Then
bCanSave = True
' InsertDB
MsgBox "on peut inserer le nouveau compte dans la BDD", vbExclamation
' StatusBar2.SimpleText "on peut insérer un nouveau compte"
' Combo1.Text = ""
Else 'si cette condition n'est pas vérifiée If CanAdd(Mid(sPrefix, 1, ACCLEN - 1)) = True
If Mid(sPrefix, ACCLEN, 1) = "0" Then
If CanAdd(Mid(sPrefix, 1, ACCLEN - 2)) = True Then
bCanSave = True
' InsertDB
MsgBox "nous pouvons inserer ce nouveau compte dans la BDD", vbExclamation
' Combo1.Text = ""
Else 'si CanAdd(Mid(sPrefix, 1, ACCLEN - 2)) = True n'est pas vérifiée
MsgBox "il n'est pas possible de créer ce compte", vbExclamation
' Combo1.Text = ""
End If ' fin de CanAdd(Mid(sPrefix, 1, ACCLEN - 2)) = True
Else 'si Mid(sPrefix, ACCLEN, 1) = "0" n'est pa vérifiée
MsgBox "il n'est pas possible de créer ce nouveau compte", vbExclamation
' Combo1.Text = ""
End If ' fin de If Mid(sPrefix, ACCLEN, 1) = "0" Then
End If 'fin de If CanAdd(Mid(sPrefix, 1, ACCLEN - 1)) = True
'
End If ' fin de If Len(sPrefix) = ACCLEN
End If ' fin de if bValid=false
Else 'if len(sPrefix)>ACCLEN
If KeyAscii = 13 Then
InsertDB
nouvcpte.Text = ""
End If
'
End If 'fin de if len(sPrefix)<=5
End Sub
here is the code which works well
Code:
Public cn As ADODB.Connection
Private sPrefix As String
Private s As String
Private bCanSave
Private bValid
Const ACCLEN = 2 in this case acclen=2
Dim i As Integer
Private Sub Combo1_KeyPress(KeyAscii As Integer)
bValid = True
'''cas où j'ai tapé 3 caractères
If Len(sPrefix) < ACCLEN Then
' si le caractère saisi est le Backspace alors
' '
If KeyAscii = 8 Then
If Len(sPrefix) > 0 Then
sPrefix = Mid(sPrefix, 1, Len(sPrefix) - 1)
End If
Exit Sub ' faire attention à ce exit sub
End If
For i = 1 To Combo1.ListCount - 1
s = Mid(Combo1.List(i), 1, 2)
If Len(sPrefix) = ACCLEN - 1 And sPrefix & Chr(KeyAscii) = s Then
MsgBox "ce nombre a déjà été saisi", vbExclamation
Exit For
bValid = False
End If
If Mid(s, 1, Min(2, Len(sPrefix) + 1)) = sPrefix & Chr(KeyAscii) Then
bValid = True
' Exit For
End If
Next i
If bValid = False Then
MsgBox "ce nombre n'est pas valide", vbExclamation
Else
sPrefix = sPrefix & Chr(KeyAscii)
bCanSave = True
End If
'If Existe(sPrefix) Then
'MsgBox "ce compte existe déjà", vbExclamation
'End If
Else ' si len(sPrefix)>1 c'est à dire =2 au moins (on a tapé au moins trois caractères)
If KeyAscii = 13 Then
InsertDB
Insertlibelle
Combo1.Text = ""
End If
End If
End Sub
What Is The Maximum Lenght Of FileReport
Hi,
This ia Lalitha, I am using File Reports for my Vb Project, in that i am using 132 column lenght, now i need more than that colimn width. Is there any Possibilities plz tell me.
What is then maximum length of File Report?
It's urgent for me.
Thanks in advance.
Lalitha.C
Null On Textbox??? Or Zero Lenght ???
Hello !
I have textbox that connect to Data/Time field in database by data control.
When the form is show the textbox is empty because the field is empty... So far is good...
When I type some text to textbox and after that I delete the text from it I got that Error :
"Field can not be Zero lenght..."
What can I do ?
I try to type:
"text1.text = Null" but there is error
please Help !
Thanks !
String Lenght Completing Problem
Hi all,
I have a textbox, in which the user can write decimal numbers from 0 to 999999. I convert it to hex, then I'd like to put it in a srting (let's call it:"sstring1").
My problem is, that I'd like to complete the string to 6 digits with zeros, so it would look like this:
"00 00 2e" instead of this: "2e". So when I put "sstring" into a file, it will write the zeros as well, not only the hexadecimal value into a specified address of the file.
thank you in advance
Splitting Cellinfo With Changing Lenght
hello again,
I have a little problem.
I a cell i have some info like this
eg.:
cell a1=
Name, Street nr, Pcode City
But every time another lenght, like this:
De Volder Christian, changinglane 123, 8000 Brugge
De Volder C., Everybodysstreet 12 / 2, 8210 Zedelgem
I'd like to read that info into different textboxes in VBA
How can i do that?
Thx
String Lenght-related Problem
Hey,
I am implementing kinda route table in a game to select a route from points. Obviously I need various routes. It's like I need to tell several units where to go and what to do there, and then proceed.
The route-points are numbered. So I cramp these numbers (and the numbers that describe the actions) together into a string of numbers (like "200150026" = 2 actions, goto point 001 and do 5, then goto point 002 and gimme six, start over).
The problem is, this does not seem to work infinitivly. Though I use Str$, with the string becoming longer than 30 chars I get strange things like "5.e" etc. which I cannot convert back of course.
So, I wanted to ask you: What is the character-limit for a String? Or should I use a DB (geez I'm new at this, have mercy..) for this already?
Thanx!
How Do You Make A Variable Lenght String?
I noticed that the lenght for a variable lenght string is 2 billion characters, and incase I go over 64k (highly unlikely, but still), I'd like to know how to declare some of my strings for a longer length.
Thanks!
|
TRACKER
