Databases
StackOverflow2013
Postsdbo
POCall a sub using a string-variable
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCall a sub using a string-variable
    primarykey
    data
    text
    <p>I have a SQL-database in which I list conditions that mails have to meet.</p> <p>For every mail that I receive the database is searched, and if the conditions of one of the records are fulfilled, another Sub shall be called for the Mail. Which Sub is to be executed is defined in the database as well.</p> <p>Everything works fine, but I am not able to call the Sub. </p> <pre><code>Sub automatik_sql() 'VERWEIS auf ActiveX Data Objects 6.1 Library notwendig' Dim olApp As Outlook.Application Dim olitem As Outlook.MailItem Set olApp = Outlook.Application Set olitem = Application.ActiveInspector.CurrentItem Dim con As ADODB.connection Dim rec As ADODB.recordset Dim MySQL As String Dim ausloeser As Boolean ausloeser = True MySQL = "SELECT MA_Index, beding_body, beding_subj, aktion FROM Mail_Automatik where (empfaenger = '" &amp; olitem.To &amp; "' and absender ='" &amp; olitem.SenderEmailAddress &amp; "')" Set con = New ADODB.connection con.Open "Provider=sqloledb; Data Source=meinedaten; Initial Catalog=STAMMDATEN; INTEGRATED SECURITY=sspi;" Set rec = con.Execute(MySQL) While Not rec.EOF If Not IsNull(rec.Fields("beding_body").Value) Then If InStr(olitem.Body, rec.Fields("beding_body").Value) = 0 Then ausloeser = False End If If Not IsNull(rec.Fields("beding_subj").Value) Then If InStr(olitem.Subject, rec.Fields("beding_subj").Value) = 0 Then ausloeser = False End If </code></pre> <p>and now i have the Problem:</p> <pre><code>If ausloeser = True Then Call rec.Fields("aktion") rec.movenext Wend End Sub </code></pre> <p>As I am working on a german-language machine I only have the error (poping up at the start of the Sub) in german: </p> <blockquote> <p>Fehler beim kompilieren: Unzulässige Verwendung einer Eigenschaft Translation: "failed to compile: illegal use of a property "</p> </blockquote> <p>Anyone have any idea?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMax
    1. USMax
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCall a sub using a string-variable
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COIt might be worth adding an english translation of that error: "Compiler Error: Disallowed use of a Property"
      singulars
      1. POCall a sub using a string-variable
      1. USmaxf130
    2. CO`Fehler beim kompilieren: Unzulässige Verwendung einer Eigenschaft` translates to `Failed to compile: illegal use of a property`
      singulars
      1. POCall a sub using a string-variable
      1. USChris
    3. COthanks @Cube32 and @maxf130!
      singulars
      1. POCall a sub using a string-variable
      1. USMax
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload