Thanks for the code StoneDeCroze, this really helps me get going. Being a python newbie examples that apply to what I am trying to do are very helpfull.
Thanks again.
nv_wildfire
StoneDeCroze,
Thanks for the reply, here are a few lines of the csv file.
42.23133813, -121.44313522, "maybe1", ff00ff
42.23132888, -121.43319847, "maybe1", ff00ff
42.22792478, -121.43320996, "maybe1", ff00ff
42.22802306, -121.44307129, "maybe1", ff00ff...
I know this is a very simple question, but being a python newbie I need some help (this is my first project trying to use python instead of VB).
I have a CSV file that is exported from a program called terrain navigator, I want to read in the data from the CSV file and then write it out as an...
...in an sql statement while connecting to MS access with ADO use "%" as your wildcard character. When using wildcards in MS access use "*" as your wildcard character. It took the help of others and many frustrated hours to figure this out.
Thank you for everyones help.
kgk
Thanks for the input everyone. I'll try using brakets around my field name in the WHERE clause and I'll also add the % instead of *.
Shaddow,
I am connecting to access with the Jet OLEDB provider.
I won't be able to try this until monday when I am back at work.
kgk
...statement:
strSQLS = "SELECT tblCache.NFES, tblCache.Description FROM tblCache "
strSQLS = strSQLS & "WHERE ((Description) like '*' & 'jean' & '*')"
Here is the ADO Request:
objRsSearch strSQLS, objConn
If I copy this statement straight into the sql view of a query, 23...
CajunCenturion,
Thanks for the input.
To add a report object do I assume I have to add the report control to my tool box? I have done so but the icon it adds just say OCX (doesn't have an icon that looks to have any meaning) and gives a .dll error when I try to add it to my form? Any...
Thanks everyone for the quick response. I am now starting to realize what my problem is. I am using VBA instead of VB. I am thinking that textwidth is not available in VBA? Can anyone confirm this? Thanks in advance.
kgk
My dilemma is that the software I am using (ArcMap 8.2) does not have word wrap for its text elements. So when I have a user enter a bunch of text on a form and then when I try to place that text on a map as a text element (basically a label) the text will extend out until the end of the string...
...how do I recall that information for use in a label. Hope that makes sense. I know I could just edit the label manually each time I create a new *.exe but I am to say the least very forgetful and would most likely forget to change the version in the app.
Anyway I think this is an easy...
...= "tmpDBF1.dbf"
End If
Else
strFileTitle = strFileTitle
End If
strSQL = "SELECT * FROM " & strFileTitle
Set fConn = New ADODB.Connection
fConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _...
...someone out there can see my error or at least point me in the right direction. The following is the code I am using:
strSQL = "SELECT * FROM " & dlgOpenDBF.FileTitle
Set fConn = New ADODB.Connection
fConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _...
Hello everyone, I think this is an easy question so here it is. I am creating a DBF file with ADO, the following is the code used:
Set fConn = New ADODB.Connection
fConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & OPath & ";"...
...As ADODB.Recordset
Dim strSQL As String
Dim strTxtBox As String
Dim objTxtBox As Object
Dim i As Integer
strSQL = "SELECT * From tblFireRegime "
Set RS = New ADODB.Recordset
With RS
.CursorType = adOpenStatic
.LockType =...
CajunCenturion,
Thanks for the help. I think your idea will work perfectly. My only concern is that the array should be shuffled so that not all numbers with a high probability are together. This may be an invalid concern, I don't know. Again many thanks for your input.
Thanks you,
kgk
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.